[Commits] Rev 2882: Enable testcase for BUG#49129 in file:///home/psergey/dev2/5.3-fix-subq/

Sergey Petrunya psergey at askmonty.org
Mon Jan 17 14:09:32 EET 2011


At file:///home/psergey/dev2/5.3-fix-subq/

------------------------------------------------------------
revno: 2882
revision-id: psergey at askmonty.org-20110117120930-12pdu1ltxo8dxvbq
parent: psergey at askmonty.org-20110114230704-gir8fiw4pjvd0cjo
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.3-fix-subq
timestamp: Mon 2011-01-17 15:09:30 +0300
message:
  Enable testcase for BUG#49129
=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result	2011-01-17 12:09:30 +0000
@@ -26,9 +26,9 @@
 1
 2
 3
+SET SESSION optimizer_switch = 'semijoin=off';
 
 # This result is correct
-SET SESSION optimizer_switch = 'semijoin=off';
 SELECT * FROM t0 WHERE t0.a IN 
 (SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
 a

=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/t/disabled.def'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/disabled.def	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/disabled.def	2011-01-17 12:09:30 +0000
@@ -1,6 +1,5 @@
 # Disabling all subquery problems
 
-bug49129             : Wrong result with IN-subquery with join_cache_level=6 and firstmatch=off
 bug45221             : Query "SELECT pk FROM C WHERE pk IN (SELECT # int_key)" failing
 bug45219             : Azalea crash on query containing a JOIN in subquery
 



More information about the commits mailing list