Read more

Known MariaDB version incompatibilities

Stefan Langenmaier
August 23, 2019Software engineer at makandra GmbH

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

Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

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.

SELECT MIN(NOW)

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

Posted by Stefan Langenmaier to makandra dev (2019-08-23 14:14)