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/t/select.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/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 14 |
1 files changed, 14 insertions, 0 deletions
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; + |