Le 10/07/12 21:44, Jeroen De Dauw a écrit :
Hey,
I got a unit test (added here: https://gerrit.wikimedia.org/r/#/c/14870/) causing some error which I can't figure out the cause of.
The error is "Error: 1137 Can't reopen table: 'unittest_smw_ids'", full message here: http://dpaste.org/B2npZ/
Anyone an idea what might be going on?
That is a MySQL bug submitted in May 2005: http://bugs.mysql.com/bug.php?id=10327
Test: create temporary table tt (x int); select * from tt as t1, tt as t2;
Trigger the 1137 error. Basically you cant reference the same temporary table more than once in the same query :/ Platonides had the issue with r102411:
http://www.mediawiki.org/wiki/Special:Code/MediaWiki/102411#c29123
The workaround was to skip the query: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/109024
:(