Last modified: 2014-09-23 23:19:08 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 32118 - test special pages SQL queries against supported Open Source DB (sqlite, mysql, pgsql)
test special pages SQL queries against supported Open Source DB (sqlite, mysq...
Status: NEW
Product: MediaWiki
Classification: Unclassified
Unit tests (Other open bugs)
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on: 37702
Blocks: 31913
  Show dependency treegraph
Reported: 2011-11-01 13:27 UTC by Antoine "hashar" Musso (WMF)
Modified: 2014-09-23 23:19 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Antoine "hashar" Musso (WMF) 2011-11-01 13:27:44 UTC
Per Brion comment on bug 31913:
We should be having unit tests running all the query page queries to make sure they work.

As an example: Microsoft SQL does not support column alias in GROUP BY clause (bug 31913).
Comment 1 Sumana Harihareswara 2011-11-02 22:02:22 UTC
DJ Bauch and Ben Lobaugh are going to work on this, at least for Microsoft-related databases.  It would be great if developers on other databases also wrote some unit tests.

From IRC discussion today:

    <MaxSem> throw some test data at it, then call internally via the API?
    <blobaugh> without having the test know how to access the db itself you could do that. insert via api and retrieve via api, compare
    <blobaugh> sumanah: i can work with djbauch to make sure the MSSQL driver is fully tested
    <djbauch> Yeah, I can work with Ben on all the required MS SQL tests.
    <blobaugh> sumanah: is there no specification for test for dbs right now?
    <G_SabinoMullane> Nikerabbit: I don't think so.
    <MaxSem> blobaugh, first, you have to get normal tests to work on your backend
    <DJ Bauch> Special pages are working OK for me now on SQL Server. Even the GROUP BY stuff

Conclusion -- Ben & DJ to work on this - for MSSQL at least. if an abstract method can be ported to each we will try to find it
Comment 2 Antoine "hashar" Musso (WMF) 2011-11-08 16:22:59 UTC
QueryPages object added with r102411
Comment 3 Rob Lanphier 2011-12-20 19:34:43 UTC
For open source databases that are easy for us to maintain, that should be higher priority than proprietary databases (e.g. Oracle, MSSQL).  I'd prefer this be split up into at least two bugs (non-proprietary and proprietary) with the proprietary ones taking lower priority.
Comment 4 Mark A. Hershberger 2011-12-21 03:21:19 UTC
Split off separate bug for the proprietary DBs: Bug 33290

Note You need to log in before you can comment on or make changes to this bug.