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
:(
--
Antoine "hashar" Musso