Posted 3 months ago. Visible to the public.

Known MariaDB version incompatibilities

MariaDB (and MySQL) is released in different versions with different behaviors. For backwards compatibility this can be managed with the sql_mode option.

Following you can find behavior differences which cannot be changed by this option. This can cause a regression in an existing application. There is no workaround available. The application needs to be adapted.

Queries with aggregated date types

For a database instance of MariaDB-10.1 or higher the result of the following query has changed.

Copy
SELECT MIN(NOW)

Before, this returned the current time as String, now this is of type Datetime.

Once an application no longer requires constant development, it needs periodic maintenance for stable and secure operation. makandra offers monthly maintenance contracts that let you focus on your business while we make sure the lights stay on.

Owner of this card:

Avatar
Stefan Langenmaier
Last edit:
3 months ago
by Stefan Langenmaier
About this deck:
We are makandra and do test-driven, agile Ruby on Rails software development.
License for source code
Posted by Stefan Langenmaier to makandra dev
This website uses cookies to improve usability and analyze traffic.
Accept or learn more