Posted over 2 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.
CopySELECT MIN(NOW)
Before, this returned the current time as String, now this is of type Datetime.
Does your version of Ruby on Rails still receive security updates?
Rails LTS provides security patches for old versions of Ruby on Rails (3.2 and 2.3).
