:/ Actually, the API people aren't the only ones doing ugly things like that. It looks like Semantic MediaWiki is sending in an ugly "DISTINCT $pagetable.page_title as title, $pagetable.page_namespace as namespace, $pagetable.page_id as id", So now I need to tweak the test to check for DISTINCT and AS or else we'll have yet another bug report.
~Daniel Friesen(Dantman) of: -The Gaiapedia (http://gaia.wikia.com) -Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG) -and Wiki-Tools.com (http://wiki-tools.com)
Roan Kattouw wrote:
DanTMan schreef:
We've got multiple options on how to fix this:
- Find a better way to make complex queries using the Database class
that doesn't involve building complex queries, and then trying to shove them into the simple handlers. This would greatly improve cross-db compatibility if done.
That should definitely happen. More specifically, we should have support for LEFT/RIGHT JOINs in the Database class. I think this kind of obsoletes 2, 3 and 4, because the only occasion on which the API sends full-blown SQL to Database::select() is to do LEFT JOINs.
Roan Kattouw (Catrope)
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l