diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-03-04 10:09:17 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-03-05 16:25:30 +0100 |
| commit | 70f5fabdbf50abb494304baaf863feac3fbd5dd9 (patch) | |
| tree | 055f2560fae665ec7ffeb4847ca5179a085adb1a /mysql-test/t/null.test | |
| parent | ff93b77fd62bdb708e2b2b34f4e2202c12e727c4 (diff) | |
| download | mariadb-git-70f5fabdbf50abb494304baaf863feac3fbd5dd9.tar.gz | |
MDEV-9682 Assertion `0' failed in Item_cache_row::illegal_method_call on 2nd execution of PS with NULLIF
don't cache Item_cache
Diffstat (limited to 'mysql-test/t/null.test')
| -rw-r--r-- | mysql-test/t/null.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index 85c7131c33b..cdc9ceb27e0 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -988,6 +988,15 @@ insert into t1 values ('2015-12-31'); select power( timestamp( nullif( '2002-09-08', f1 ) ), 24 ) from t1; drop table t1; +# +# MDEV-9682 Assertion `0' failed in Item_cache_row::illegal_method_call on 2nd execution of PS with NULLIF +# +CREATE TABLE t1 (f1 INT); +INSERT INTO t1 VALUES (1),(2); +PREPARE stmt FROM "SELECT * FROM t1 WHERE NULLIF( ( 1, 2 ) IN ( SELECT 3, 4 ), 1 )"; +EXECUTE stmt; +EXECUTE stmt; +DROP TABLE t1; --echo # --echo # End of 10.1 tests --echo # |