On 26.10.2011 7:16, Jeremy Baron wrote: > Hi, > > On Tue, Oct 25, 2011 at 22:55, Dmitriy Sintsov<[email protected]> wrote: >> Hi! >> Speaking of non-MySQL databases: recently I decided to try converting >> manually crafted SQL strings (mostly MySQL selects) to DBMS-independent >> Database::select() calls with arrays. However I've stumbled with serious >> problems with table aliases. I am not a DBMS guru, so there might be my >> fault, of course, however it would be nice if someone could answer to my >> bugreport there: >> https://bugzilla.wikimedia.org/show_bug.cgi?id=31534 >> Dmitriy > Did you test the code offered in comment 1 on that bug? > > I assume >> array( 'qp_users_polls', 'qu' => 'qp_users' ), > should instead be >> array( 'qup' => 'qp_users_polls', 'qu' => 'qp_users' ), > (from comment 1) > > Seems cleaner and saner than yours, why not give it a try? (although > yours is also cleaner and saner than the original way you found it! > (that you quoted)) > > How would Sam's code guess alias for qp_users_polls ? I thought he just forgot to put the alias key 'qup' there, writing in hurry, probably.
'qu.uid=qup.uid' probably should fail in his code. Dmitriy _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
