diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2018-09-06 22:45:19 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2018-09-06 22:45:19 +0200 |
| commit | 31081593aabb116b6d8f86b6c7e76126edb392b4 (patch) | |
| tree | 767a069f255359b5ea37e7c491dfeacf6e519fad /mysql-test/t/sp.test | |
| parent | b0026e33af8fc3b25a42099c096a84591fd550e2 (diff) | |
| parent | 3a4242fd57b3a2235d2478ed080941b67a82ad1b (diff) | |
| download | mariadb-git-31081593aabb116b6d8f86b6c7e76126edb392b4.tar.gz | |
Merge branch '11.0' into 10.1
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 467d3b5a7d4..2cdcc860506 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -9349,6 +9349,27 @@ where 1=1; drop function if exists f1; drop table t1,t2; +--echo # +--echo # MDEV-16957: Server crashes in Field_iterator_natural_join::next +--echo # upon 2nd execution of SP +--echo # + +CREATE TABLE t1 (a INT, b VARCHAR(32)); +CREATE PROCEDURE sp() SELECT * FROM t1 AS t1x JOIN t1 AS t1y USING (c); +--error ER_BAD_FIELD_ERROR +CALL sp; +--error ER_BAD_FIELD_ERROR +CALL sp; +--error ER_BAD_FIELD_ERROR +CALL sp; +alter table t1 add column c int; +CALL sp; + +# Cleanup +DROP PROCEDURE sp; +DROP TABLE t1; + + --echo # End of 5.5 test --echo # |