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/r/null.result | |
| 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/r/null.result')
| -rw-r--r-- | mysql-test/r/null.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index b8acc3e7319..f321ac978f5 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -1558,6 +1558,14 @@ insert into t1 values ('2015-12-31'); select power( timestamp( nullif( '2002-09-08', f1 ) ), 24 ) from t1; ERROR 22003: DOUBLE value is out of range in 'pow(cast((case when '2002-09-08' = '2015-12-31' then NULL else '2002-09-08' end) as datetime(6)),24)' drop table t1; +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; +f1 +EXECUTE stmt; +f1 +DROP TABLE t1; # # End of 10.1 tests # |