Description:
On the "linux x86 sysqa" platform in Pushbuild, the test rqg_opt_subquery is often failing with the following in the test log:
----------------------------
# 2011-01-17T00:57:20 Query: SELECT MAX( DISTINCT alias1 . `col_varchar_nokey` ) AS field1 , alias1 . `col_time_key` AS field2 FROM ( CC AS alias1 INNER JOIN ( ( ( SELECT SQ1_alias1 . * FROM ( ... failed: 1054 Unknown column '%s' in 'on clause'. Further errors of this kind will be suppressed.
[PB2] The child process exited without handshake.
[PB2] Mon Jan 17 01:27:22 CET 2011
[PB2] last line before timeout: <Mon Jan 17 00:57:20 CET 2011> # 2011-01-17T00:57:20 Query: SELECT MAX( DISTINCT alias1 . `col_varchar_nokey` ) AS field1 , alias1 . `col_time_key` AS field2 FROM ( CC AS alias1 INNER JOIN ( ( ( SELECT SQ1_alias1 . * FROM ( C AS SQ1_alias1 INNER JOIN C AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_nokey` = SQ1_alias1 . `col_varchar_key` AND ( SQ1_alias1 . `pk` , SQ1_alias1 . `pk` ) NOT IN ( SELECT C_SQ1_alias1 . `col_int_nokey` AS C_SQ1_field1 , SUM( C_SQ1_alias1 . `col_int_key` ) AS C_SQ1_field2 FROM ( BB AS C_SQ1_alias1 LEFT JOIN CC AS C_SQ1_alias2 ON (C_SQ1_alias2 . `col_varchar_key` = C_SQ1_alias1 . `col_varchar_key` ) ) ) ) ) ) AS alias2 LEFT JOIN CC AS alias3 ON (alias3 . `pk` = alias2 . `col_int_nokey` ) ) ) ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_nokey` ) ) WHERE ( ( alias2 . `col_varchar_key` , alias2 . `col_varchar_nokey` ) IN ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 , SQ2_alias1 . `col_varchar_key` AS SQ2_field2 FROM ( C AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 RIGHT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_varchar_nokey` = SQ2_alias2 . `col_varchar_key` AND SQ2_alias1 . `col_varchar_nokey` = ( SELECT SUM( C_SQ2_alias1 . `col_varchar_nokey` ) AS C_SQ2_field1 FROM CC AS C_SQ2_alias1 ) ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) HAVING SQ2_alias2 . `col_int_key` > 40 ) ) AND alias1 . `pk` IN (42) AND alias2 . `col_varchar_key` < 'y' GROUP BY field2 ORDER BY alias1 . `col_time_key` ASC, field1, field2 LIMIT 100 failed: 1054 Unknown column '%s' in 'on clause'. Further errors of this kind will be suppressed.
----------------------------
There is no downloadable vardir available from the failed test runs, making further log analysis impossible.
The failure is so far only visible on the "linux x86 sysqa" platform (i.e. not Solaris 10 nor Windows 2003), which is 32-bit, and only in mysql-5.1.
The first occurrence of such a failure seems to be:
Branch: mysql-5.1
Push date: 2011-01-13 02:26:44
Revision: bjorn.munch@oracle.com-20110112222953-xhso3rjm0isfgvxn
The subsequent pushes to that branch resulted in the following results:
martin.hansson@oracle.com-20110113075715-2q5k9c2xk19lq2bg - FAIL
georgi.kodinov@oracle.com-20110113085911-ndovo0rwbqfsbf46 - FAIL
nirbhay.choubey@sun.com-20110113102642-4i7chbqdhq7gj55e - PASS
luis.soares@oracle.com-20110113114100-82kaxaq975qkd8i2 - PASS
sven.sandberg@oracle.com-20110114103312-ckj0gbf1zxf6bdsl - FAIL
nirbhay.choubey@sun.com-20110114142034-6xi85qdu54cysf7q - FAIL
holyfoot@mysql.com-20110114205609-bcqgut1simvvy4pm - FAIL
anders.song@greatopensource.com-20110115055141-99bkbyyxjqy9fey9 - FAIL
nirbhay.choubey@sun.com-20110115203408-8sii20wb5owr11rj - FAIL
The RQG in Pushbuild was updated Jan 14 at about 09:45 CET.
Setting category to "Tests" for now, as not sure yet if this is a test issue or a product bug.
How to repeat:
RQG command, similar to the one used in Pushbuild ($CODE is reference to MySQL binaries):
perl pb2gentest.pl $CODE $PWD/vardir mysql-5.1 rqg_opt_subquery
(Not repeatable on OpenSolaris 64-bit.)
