Bug#54110: Extra rows returned on JOIN of two tables with join_cache_level 5 to 8 Diff from running attached MTR test case against next-mr-opt-backporting as compared to 6.0-codebase-bugfixing: --- issue1.result 2010-05-31 18:41:29.359809796 +0300 +++ issue1.reject 2010-05-31 18:41:37.476443761 +0300 @@ -51,10 +51,114 @@ FROM F table1 LEFT JOIN N table2 ON table1 .`col_int_key` = table2 .`col_int_key` ; col_varchar_1024_latin1_key -NULL -NULL -NULL -NULL +m +m +m +m +p +p +p +p +now +now +now +now +TSUNV +TSUNV +TSUNV +TSUNV +string1 +string1 +string1 +string1 +how +how +how +how +OYPEN +OYPEN +OYPEN +OYPEN +q +q +q +q +d +d +d +d +tell +tell +tell +tell +string2 +string2 +string2 +string2 +y +y +y +y +k +k +k +k +your +your +your +your +ok +ok +ok +ok +like +like +like +like +UILXF +UILXF +UILXF +UILXF +my +my +my +my +VPZDI +VPZDI +VPZDI +VPZDI +t +t +t +t as +string3 +string3 +string3 +string3 +when +when +when +when +I +I +I +I +string4 +string4 +string4 +string4 +string5 +string5 +string5 +string5 +at +at +at +at +his +his +his +his DROP TABLE F; DROP TABLE N; mysqltest: Result length mismatch