Test on a "production" database

[bear454]

I'm submitting a ..

• Bug Report
• Feature Request

Current behavior:

Continuous testing on Travis CI is run on a Sqlite3 database; as of filing this issue, running our test suite on either MariaDB or Postgres results in intermittent failures.

Expected correct behavior:

Travis CI runs on either MariaDB or Postgres, without introducing flakiness.

Other information:

Introduced in #2225.

[Ana06]

@bear454 we could run travis twice with a different database. Would you like to set this up? You would need to fix the failures, but after that we would ensure that this keep working in every PR. 🤔

[hennevogel]

@Ana06 read the discussion in #2225

[AndrewKvalheim]

Tests are passing reliably for me on PostgreSQL after merging:

• Decouple tests from unspecified data ordering Decouple tests from unspecified data ordering #2650, Decouple tests from unspecified data ordering (part 2) #2652
• Fix access to the version history of organization-level roles Fix access to the version history of organization-level roles #2654
• Fix bug in UserDatatable query affecting PostgreSQL Fix bug in UserDatatable query affecting PostgreSQL #2656
• Use Rails transactional tests Use Rails transactional tests #2659
• Fix bug in test of animated form Fix bug in test of animated form #2662