diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2017-09-06 19:28:51 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2017-09-06 19:28:51 +0300 |
commit | 70db1e3b8adc1ef88bcbda2e69a30f17b7f87d0f (patch) | |
tree | 5eea378d9752f55471ea2bc35f83ad5675471485 /mysql-test/r/sp.result | |
parent | c59a52b7bad473a162a51000f2a24507c83b5fc8 (diff) | |
parent | 7008d4616421fdf73d109ed297def27fa4679da4 (diff) | |
download | mariadb-git-70db1e3b8adc1ef88bcbda2e69a30f17b7f87d0f.tar.gz |
Merge 10.1 into 10.2
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 08d69e102b4..1e728bd162a 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -8087,6 +8087,34 @@ CALL sp1(); CALL sp1(); drop user 'foo'@'%'; drop procedure sp1; +# +# MDEV-10972: Insert from select / view / union -- +# repeatable crash in 10.1, 10.2 Linux/Mac/Windows +# +create table t (id int auto_increment primary key); +insert into t values (9494),(9495),(9496),(9497),(9498),(9499),(9500),(9501),(9502),(9503); +create VIEW v AS +select id from t +union +select id from t +; +drop procedure if exists p; +Warnings: +Note 1305 PROCEDURE test.p does not exist +create procedure p() +insert into tmp_t select t.id from ( +select id from v +union +select id from v +) sq +inner join t on (sq.id = t.id); +CALL p(); +ERROR 42S02: Table 'test.tmp_t' doesn't exist +create table tmp_t (id int null); +CALL p(); +drop procedure p; +drop view v; +drop table t, tmp_t; #End of 10.1 tests # # MDEV-11081: CURSOR for query with GROUP BY |