diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-06-08 10:47:23 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-06-08 10:47:23 +0400 |
| commit | a16f4eeea78d982d15409c34ee6a268cb8ac7d5d (patch) | |
| tree | 3b88669e4b69c4a2ad83a10c7beace89b7fc2e0c /mysql-test/r/func_isnull.result | |
| parent | a961688d2e443d2c1a72c62edfaa9d6e111e3f51 (diff) | |
| parent | 81e6a982508b45b93b46d5610cd462711fdab98e (diff) | |
| download | mariadb-git-a16f4eeea78d982d15409c34ee6a268cb8ac7d5d.tar.gz | |
5.1-bugteam->trunk-merge merge
Diffstat (limited to 'mysql-test/r/func_isnull.result')
| -rw-r--r-- | mysql-test/r/func_isnull.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/func_isnull.result b/mysql-test/r/func_isnull.result index 79aecc7d82b..2dbe3d036f9 100644 --- a/mysql-test/r/func_isnull.result +++ b/mysql-test/r/func_isnull.result @@ -5,6 +5,20 @@ flush tables; select * from t1 where isnull(to_days(mydate)); id mydate drop table t1; +# +# Bug#53933 crash when using uncacheable subquery in the having clause of outer query +# +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; +f2 +0 +SELECT RELEASE_LOCK('Bug#53933'); +RELEASE_LOCK('Bug#53933') +1 +DROP TABLE t1; +End of 5.0 tests CREATE TABLE t1 (id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id)); INSERT INTO t1( id ) VALUES ( NULL ); SELECT t1.id FROM t1 WHERE (id is not null and id is null ); |