List:Commits« Previous MessageNext Message »
From:Olav Sandstaa Date:November 8 2010 9:30am
Subject:bzr push into mysql-next-mr-bugfixing branch (olav.sandstaa:3278 to 3279)
View as plain text  
 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 Sandstaa8 Nov