Hi, 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. * Background 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)`. https://github.com/rails/rails/issues/24288 https://github.com/rails/rails/issues/24677 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. https://github.com/rails/rails/commit/42dd2336b31a8d98776d039a2b9fd7f834156a78 * 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 3.7.15.1 causes at two failures in NestedThroughAssociationsTest which did not reproduce using SQLite 3.7.9 and 3.8.2 https://github.com/rails/rails/pull/24440 - Ubuntu 14.04 LTS runs SQLite version 3.8.2 All ActiveRecord unit tests passed without errors Refer https://docs.travis-ci.com/user/ci-environment/#Virtualization-environments Thanks, -- Yasuo Honda -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/rubyonrails-core. For more options, visit https://groups.google.com/d/optout.
