On 26.10.2011 7:27, Jeremy Baron wrote: > On Tue, Oct 25, 2011 at 23:23, Dmitriy Sintsov<[email protected]> wrote: >> 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. > Did you miss half of what I said? I'll quote myself so you can be sure > to see it this time: >> I assume >>> array( 'qp_users_polls', 'qu' => 'qp_users' ), >> should instead be >>> array( 'qup' => 'qp_users_polls', 'qu' => 'qp_users' ), >> (from comment 1) > I am not native English speaker, sorry. However, in that bugreport there is second (different) query converted from MySQL string to Database::select() with arrays. It has INNER JOIN. The source query works fine, the converted one fails because table aliases are 'quoted'. Should I do not use table aliases at all? Dmitriy
_______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
