On 02/25/2013 12:53 PM, Sumana Harihareswara wrote:
The question: what do we need to test more often to keep RDBMSes happy? https://www.mediawiki.org/wiki/Database_testing & https://www.mediawiki.org/wiki/New_installer/Test_plan Permissions, searching, schema setup, schema changes, quoting & identifiers, weird page names, transactions, import, dump, & interface coverage seem like the main culprits.
Sure, for starters. :) Bear in mind, if we want to keep support for all these dbs, every change to the database schema has to (at some point) result in a change to separate SQL files for each DB (MySQL and SQLite use the same ones). For instance, there is a separate active oracle/tables.sql.
Then, we need to make sure it actually works as intended for all the dbs. We do have database tests. As people noted, just having Jenkins run all the existing tests for every db would be a major step forward. We *only* run them for SQLite (not even MySQL!).
See https://bugzilla.wikimedia.org/show_bug.cgi?id=35912
Matt Flaschen