diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2011-05-10 16:57:40 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2011-05-10 16:57:40 +0300 |
| commit | 9477fd28791ba2df5cfc84d1f1dc469d6768e8ec (patch) | |
| tree | 1810b2ffcaac02578a8a1a932c8a69ce1114d54e /mysql-test/t/subselect.test | |
| parent | e6964a2a7478138f55cb770d26c7ab0a29113d72 (diff) | |
| parent | ef2d701c00f7362dce500fdcb227627e21b0ceb8 (diff) | |
| download | mariadb-git-9477fd28791ba2df5cfc84d1f1dc469d6768e8ec.tar.gz | |
weave merge of mysql-5.1->mysql-5.1-security
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index e8748710f16..4c5ecbd9ee6 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -3759,3 +3759,25 @@ DROP TABLE t1,t2; --enable_result_log --echo End of 5.1 tests + +--echo # +--echo # Bug #11765713 58705: +--echo # OPTIMIZER LET ENGINE DEPEND ON UNINITIALIZED VALUES +--echo # CREATED BY OPT_SUM_QUERY +--echo # + +CREATE TABLE t1(a INT NOT NULL, KEY (a)); +INSERT INTO t1 VALUES (0), (1); + +--error ER_SUBQUERY_NO_1_ROW +SELECT 1 as foo FROM t1 WHERE a < SOME + (SELECT a FROM t1 WHERE a <=> + (SELECT a FROM t1) + ); + +SELECT 1 as foo FROM t1 WHERE a < SOME + (SELECT a FROM t1 WHERE a <=> + (SELECT a FROM t1 where a is null) + ); + +DROP TABLE t1; |