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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T34118, the corresponding Phabricator task for complete and up-to-date bug report information.
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)
unspecified
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: ---


Attachments

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.


Navigation
Links