diff options
| author | unknown <sanja@montyprogram.com> | 2014-01-26 16:41:15 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2014-01-26 16:41:15 +0200 |
| commit | 31249744fe88bccee1054398baa532f44a6c2a10 (patch) | |
| tree | d32034bd289b9cc6df07238eb214204f28db02bc /mysql-test/r/derived.result | |
| parent | c6de45584a40052754ccfa7fc27f59483af51e98 (diff) | |
| parent | d9cb1352c8256d9c19a3d29af6fe3d705578a413 (diff) | |
| download | mariadb-git-31249744fe88bccee1054398baa532f44a6c2a10.tar.gz | |
merge 5.3->5.5
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 699d3279e3e..3a3b69f1fc7 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -479,6 +479,28 @@ SELECT * FROM WHERE tmp.a; a b 100 200 +# +# MDEV-5356: Server crashes in Item_equal::contains on 2nd +# execution of a PS +# +CREATE TABLE t1 (a INT, b INT); +INSERT INTO t1 VALUES (1,2),(3,4); +CREATE TABLE t2 (c INT); +INSERT INTO t2 VALUES (5),(6); +CREATE TABLE t3 (d INT); +INSERT INTO t3 VALUES (7),(8); +CREATE PROCEDURE pr() +UPDATE t3, +(SELECT c FROM +(SELECT 1 FROM t1 WHERE a=72 AND NOT b) sq, +t2 +) sq2 +SET d=sq2.c; +CALL pr(); +CALL pr(); +CALL pr(); +drop procedure pr; +drop table t1,t2,t3; # End of 5.3 tests # # Bug#58730 Assertion failed: table->key_read == 0 in close_thread_table, |