Posted almost 3 years 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.


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

Your development team has a full backlog of feature requests, chores and refactoring coupled with deadlines? We are familiar with that. With our "DevOps as a Service" offering, we support developer teams with infrastructure and operations expertise.

Owner of this card:

Stefan Langenmaier
Last edit:
almost 3 years 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 short-lived cookies to improve usability.
Accept or learn more