#At lp:maria 2862 knielsen@knielsen-hq.org 2010-05-12 Result file update for main.subselect (the MySQL 5.1.46 version has buggy output in the .result, see BUG#47904 comments). modified: mysql-test/r/subselect.result === modified file 'mysql-test/r/subselect.result' --- a/mysql-test/r/subselect.result 2010-04-28 12:52:24 +0000 +++ b/mysql-test/r/subselect.result 2010-05-12 10:58:11 +0000 @@ -4691,9 +4691,9 @@ t1.t1_id; t1_id total_amount 1 100.00 2 200.00 -3 0 +3 0.00 4 400.00 -5 0 +5 0.00 SELECT * FROM (the same inner query), now with indexes on the LEFT JOIN SELECT * FROM ( SELECT