diff options
| author | Tor Didriksen <tor.didriksen@oracle.com> | 2011-04-15 08:54:05 +0200 |
|---|---|---|
| committer | Tor Didriksen <tor.didriksen@oracle.com> | 2011-04-15 08:54:05 +0200 |
| commit | 73c8173f44c1a95977c41ab35d85a03b9a8c5006 (patch) | |
| tree | 03f21dfd4ad78e88583ecd35be0a32609b86ef31 /mysql-test/t/subselect.test | |
| parent | 2705490f685e2a0da617601e8c4ada68261633df (diff) | |
| parent | 2af655c2e59e505390e90039d9c47fbc0fdaf493 (diff) | |
| download | mariadb-git-73c8173f44c1a95977c41ab35d85a03b9a8c5006.tar.gz | |
Merge fix for Bug#11765713 from 5.1
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 f60ee247ba7..e910ea09fb2 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -3997,6 +3997,28 @@ DROP TABLE t1,t1s,t2s; --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; + +--echo # --echo # Bug #57704: Cleanup code dies with void TABLE::set_keyread(bool): --echo # Assertion `file' failed. --echo # |