Posted 9 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.


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

Growing Rails Applications in Practice
Check out our new e-book:
Learn to structure large Ruby on Rails codebases with the tools you already know and love.

Owner of this card:

Stefan Langenmaier
Last edit:
9 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