diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-05-03 17:11:45 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-05-03 17:11:45 -0700 |
| commit | aaf9fb0de706da2924bdcb2533b1eda6933aca61 (patch) | |
| tree | cfb36bde67bdf4f788a6f7ac5688716bb1d12141 /mysql-test | |
| parent | 8ac88c88f0038350064429fda626233260eb6721 (diff) | |
| download | mariadb-git-aaf9fb0de706da2924bdcb2533b1eda6933aca61.tar.gz | |
Fixed LP bug #776274,
The bug was introduced by the patch that fixed bug 717577.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/select_jcl6.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/select_pkeycache.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 14 |
4 files changed, 53 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 56d383a57b7..f9d6c80018b 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -5018,3 +5018,16 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; diff --git a/mysql-test/r/select_jcl6.result b/mysql-test/r/select_jcl6.result index caa0fcb5cf6..ca7241d8f87 100644 --- a/mysql-test/r/select_jcl6.result +++ b/mysql-test/r/select_jcl6.result @@ -5025,6 +5025,19 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; set join_cache_level=default; show variables like 'join_cache_level'; Variable_name Value diff --git a/mysql-test/r/select_pkeycache.result b/mysql-test/r/select_pkeycache.result index 56d383a57b7..f9d6c80018b 100644 --- a/mysql-test/r/select_pkeycache.result +++ b/mysql-test/r/select_pkeycache.result @@ -5018,3 +5018,16 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index fb04562a173..3d5ffd185ba 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4211,3 +4211,17 @@ SELECT t2.f23 FROM DROP TABLE t1,t2,t3,t4,t5,t6,t7; --echo End of 5.1 tests + +--echo # +--echo # BUG#776274: substitution of a single row table +--echo # + +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); + +SELECT * FROM t1 WHERE a = b; +EXPLAIN +SELECT * FROM t1 WHERE a = b; + +DROP TABLE t1; + |