3279 Olav Sandstaa 2010-11-08
Remove the "optimizer_unfixed_bugs" test suite since it no longer contains
tests for any unfixed bugs.
@ mysql-test/suite/optimizer_unfixed_bugs/README.txt
Remove the "optimizer_unfixed_bugs" test suite since it no longer contains
tests for any unfixed bugs.
removed:
mysql-test/suite/optimizer_unfixed_bugs/
mysql-test/suite/optimizer_unfixed_bugs/README.txt
mysql-test/suite/optimizer_unfixed_bugs/r/
mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result
mysql-test/suite/optimizer_unfixed_bugs/t/
mysql-test/suite/optimizer_unfixed_bugs/t/bug49129.test
3278 Olav Sandstaa 2010-11-08
Test case for Bug #42991 "invalid memory access and/or crash when using index condition pushdown + innodb".
@ mysql-test/include/icp_tests.inc
Test case for Bug #42991 "invalid memory access and/or crash when
using index condition pushdown + innodb".
@ mysql-test/r/innodb_icp.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/r/innodb_icp_all.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/r/innodb_icp_none.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/r/myisam_icp.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/r/myisam_icp_all.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/r/myisam_icp_none.result
Result file for test for Bug #42991 "invalid memory access and/or crash
when using index condition pushdown + innodb".
@ mysql-test/suite/optimizer_unfixed_bugs/r/bug42991.result
Simplified version of test case is not included in include/icp_tests.inc.
@ mysql-test/suite/optimizer_unfixed_bugs/t/bug42991.test
Simplified version of test case is not included in include/icp_tests.inc.
removed:
mysql-test/suite/optimizer_unfixed_bugs/r/bug42991.result
mysql-test/suite/optimizer_unfixed_bugs/t/bug42991.test
modified:
mysql-test/include/icp_tests.inc
mysql-test/r/innodb_icp.result
mysql-test/r/innodb_icp_all.result
mysql-test/r/innodb_icp_none.result
mysql-test/r/myisam_icp.result
mysql-test/r/myisam_icp_all.result
mysql-test/r/myisam_icp_none.result
=== removed directory 'mysql-test/suite/optimizer_unfixed_bugs'
=== removed file 'mysql-test/suite/optimizer_unfixed_bugs/README.txt'
--- a/mysql-test/suite/optimizer_unfixed_bugs/README.txt 2010-05-19 13:01:22 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/README.txt 1970-01-01 00:00:00 +0000
@@ -1,29 +0,0 @@
-Putting testcases here
-~~~~~~~~~~~~~~~~~~~~~~
-
-When you work on re-verifying or re-classifying a bug (not fixing it),
-it's a good idea to put the mtr-parsable '.test' testcase here.
-Benefits:
-1) tests downloaded from the bugs db are sometimes close to
-mtr-parsable but not completely (for example if they contain
-/* comment */); when you re-verify or re-classify you run the test so
-may have to make it mtr-parsable; if you then put it in this suite,
-the developer who will work on this bug in a few weeks or months will
-not have to re-do the same download&fix, she/he can instead reuse your
-work.
-2) Others can see how their own work influences many unsolved
-bugs, by running this suite. If they find that they fix a bug in this
-suite, we won't later wonder "how come this bug doesn't happen
-anymore, what fixed it?".
-3) One can also run this suite with certain switches to see how they
-influence unsolved bugs:
-./mtr --suite=optimizer_unfixed_bugs \
---mysqld=--optimizer_switch="firstmatch=off"
-
-Adding tests to this suite
-~~~~~~~~~~~~~~~~~~~~~~~~~~
-One test file per bug, named bugNNNNN.test.
-Put the correct (not current and buggy) result file in r/, so that "[ pass ]"
-in mtr will mean that a bug looks like fixed.
-When you have fixed a bug, remove files from this suite.
-t/bug45219.test is an example.
=== removed directory 'mysql-test/suite/optimizer_unfixed_bugs/r'
=== removed file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result 2010-05-19 13:24:14 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug49129.result 1970-01-01 00:00:00 +0000
@@ -1,39 +0,0 @@
-SET SESSION optimizer_switch = 'firstmatch=off,index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,loosescan=on,materialization=on,semijoin=on';
-CREATE TABLE t0 (a INT);
-INSERT INTO t0 VALUES (0),(1),(2),(3),(4);
-CREATE TABLE t1 (a INT, b INT, KEY(a));
-INSERT INTO t1 SELECT a, a from t0;
-CREATE TABLE t2 (a INT, b INT, PRIMARY KEY(a));
-INSERT INTO t2 SELECT * FROM t1;
-UPDATE t1 SET a=3, b=11 WHERE a=4;
-UPDATE t2 SET b=11 WHERE a=3;
-
-# This result is wrong, but will be fixed by Bug#46556
-SELECT * FROM t0 WHERE t0.a IN
-(SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-a
-0
-1
-2
-3
-SET optimizer_join_cache_level = 6;
-
-# This result is even more wrong ;-)
-SELECT * FROM t0 WHERE t0.a IN
-(SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-a
-0
-1
-2
-3
-SET SESSION optimizer_switch = 'semijoin=off';
-
-# This result is correct
-SELECT * FROM t0 WHERE t0.a IN
-(SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-a
-0
-1
-2
-3
-DROP TABLE t0, t1, t2;
=== removed directory 'mysql-test/suite/optimizer_unfixed_bugs/t'
=== removed file 'mysql-test/suite/optimizer_unfixed_bugs/t/bug49129.test'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug49129.test 2010-05-19 13:01:22 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug49129.test 1970-01-01 00:00:00 +0000
@@ -1,34 +0,0 @@
-SET SESSION optimizer_switch = 'firstmatch=off,index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,loosescan=on,materialization=on,semijoin=on';
-
-CREATE TABLE t0 (a INT);
-INSERT INTO t0 VALUES (0),(1),(2),(3),(4);
-
-CREATE TABLE t1 (a INT, b INT, KEY(a));
-INSERT INTO t1 SELECT a, a from t0;
-
-CREATE TABLE t2 (a INT, b INT, PRIMARY KEY(a));
-INSERT INTO t2 SELECT * FROM t1;
-
-UPDATE t1 SET a=3, b=11 WHERE a=4;
-UPDATE t2 SET b=11 WHERE a=3;
-
---echo
---echo # This result is wrong, but will be fixed by Bug#46556
-SELECT * FROM t0 WHERE t0.a IN
- (SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-
-SET optimizer_join_cache_level = 6;
-
---echo
---echo # This result is even more wrong ;-)
-SELECT * FROM t0 WHERE t0.a IN
- (SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-
-SET SESSION optimizer_switch = 'semijoin=off';
-
---echo
---echo # This result is correct
-SELECT * FROM t0 WHERE t0.a IN
- (SELECT t1.a FROM t1, t2 WHERE t2.a=t0.a AND t1.b=t2.b);
-
-DROP TABLE t0, t1, t2;
No bundle (reason: useless for push emails).
| Thread |
|---|
| • bzr push into mysql-next-mr-bugfixing branch (olav.sandstaa:3278 to 3279) | Olav Sandstaa | 8 Nov |
