diff options
| author | Alexander Nozdrin <alik@sun.com> | 2010-06-17 10:19:37 +0400 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2010-06-17 10:19:37 +0400 |
| commit | b79631bc7a2cdcb46f34d6e37e1597a6e71f09b1 (patch) | |
| tree | bfb59b6d8f549e9bbacfa1e2d9b75b95ad1fb5d4 /mysql-test/t/func_isnull.test | |
| parent | 2de17fbb2b72d4121e2fa315b233236f705297cf (diff) | |
| parent | c388c044e00d193801fee45fe9e3c0d7eac928e7 (diff) | |
| download | mariadb-git-b79631bc7a2cdcb46f34d6e37e1597a6e71f09b1.tar.gz | |
Auto-merge from mysql-trunk.
Diffstat (limited to 'mysql-test/t/func_isnull.test')
| -rw-r--r-- | mysql-test/t/func_isnull.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_isnull.test b/mysql-test/t/func_isnull.test index 424f6dc6640..326574e0515 100644 --- a/mysql-test/t/func_isnull.test +++ b/mysql-test/t/func_isnull.test @@ -14,6 +14,21 @@ drop table t1; # End of 4.1 tests +--echo # +--echo # Bug#53933 crash when using uncacheable subquery in the having clause of outer query +--echo # + +CREATE TABLE t1 (f1 INT); +INSERT INTO t1 VALUES (0),(0); + +SELECT ISNULL((SELECT GET_LOCK('Bug#53933', 0) FROM t1 GROUP BY f1)) AS f2 +FROM t1 GROUP BY f1 HAVING f2 = f2; +SELECT RELEASE_LOCK('Bug#53933'); + +DROP TABLE t1; + +--echo End of 5.0 tests + # # Bug #41371 Select returns 1 row with condition "col is not null and col is null" # |