This is my first post to Rails core mailing list.
I’d like to propose that Rails 5 minimum version of SQLite 3.8 or higher.
( Here I am talking about SQLite database itself, not talking about sqlite3 gem. )
Usually I can open a pull request, but I need to know how to support SQLite 3.8 at Travis CI environment,
which can currently runs 3.7.11 by default or 3.7.15 which causes failures at ActiveRecord unit test.
Recently there are some issues reported. When more than 2 migrations migrated at the same time it fails with
ActiveRecord::StatementInvalid: SQLite3::SQLException: near ",": syntax error: INSERT INTO "schema_migrations" (version).
Since this commit will be available to Rails users who migrated to Rails 5. It has not backported to 4.2 or older version of Rails.
- Ubuntu releases and SQLite versions
Ubuntu 12.04 LTS runs SQLite version 3.7.9, which does not support multiple values in one insert statement.
Ubuntu 12.04 LTS + Travis CI PPA runs SQLite version 184.108.40.206
causes at two failures in NestedThroughAssociationsTest
which did not reproduce using SQLite 3.7.9 and 3.8.2
Ubuntu 14.04 LTS runs SQLite version 3.8.2
All ActiveRecord unit tests passed without errors