https://bugzilla.wikimedia.org/show_bug.cgi?id=67602
Marc A. Pelletier <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #4 from Marc A. Pelletier <[email protected]> --- Ah, there's clearly something stupid in the way the query is planned, because: select * FROM commonswiki_f_p.image where img_name in('Icon_tools.svg', 'Qsicon_Fokus2.svg'); instead of the third statement returns: 1 row in set (0.00 sec) which is as expected, and the planner explains that when doing your third query it is specifically _not_ using a key(!) Likewise: select * FROM commonswiki_f_p.image where img_name in(select it from DF_temp); times out (explain shows no index used). Where the problem lies might be in that the query planner somehow things there are no rows in the federated table. For that matter, even forcing the index fails to use it: select img_bits FROM DF_temp inner JOIN commonswiki_f_p.image force index (primary) ON it=img_name; also times out. This is clearly incorrect behaviour; I'll be looking into it. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
