https://bugzilla.wikimedia.org/show_bug.cgi?id=26273
Sumana Harihareswara <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected] --- Comment #4 from Sumana Harihareswara <[email protected]> 2011-11-02 23:11:19 UTC --- We discussed this bug today in IRC and did not come to any particular conclusions on how to design this. This is a large project, one that developers who want a substantial MediaWiki improvement task should take on. <G_SabinoMullane> There is a related bug to 26273 but I don't know where it is offhand. Tim and I made some hand-waving solutions for this. <G_SabinoMullane> Basically, we need to have MW gather the list of columns from the tables and create the GROUP BY on the fly. <blobaugh> G_SabinoMullane: why not have a var that lists, per table, the correct group by? <G_SabinoMullane> blobaugh: Because schema changes (new columns) would break it <djbauch> This bug (26273) used to rear its ugly head a lot. Not so much any more. It was just one special page the last time I checked. Staying away from GROUP BY 1,2,3, etc. and sticking to the more stringent rules enforced by SQL SERVER (e.g., making sure to name the fields by name rather than by alias) has helped a lot. <blobaugh> G_SabinoMullane: could this be a global that gets updated on schema changes manually? <^demon> blobaugh: We can barely keep people updating all the proper places when they do a schema change anyway...a global they'd have to keep in check too would be impossible. <blobaugh> ^demon: fair enough <G_SabinoMullane> blobaugh: That seems like a lot of work compared to simply reading the db cols directly <blobaugh> G_SabinoMullane: maybe, but it would make the system much faster than needing another db call <sumanah> djbauch: do you think it would be fairly easy to generate a list of the places in MediaWiki that name fields by alias? <djbauch> Sumanah: Yes, there were only two places that caused a problem that I found. One special page and one obscure place. <sumanah> is this a longterm project for some interested developer, then?like, GSoC level? or intractable? or what? <Nikerabbit> not sure if it is worth full GSoC, but looks like non-trivial amount of work indeed -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
