diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-11-11 18:14:49 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-11-11 18:14:49 +0400 |
| commit | 1c459785127d40db78cf763f0e9e99e99693387c (patch) | |
| tree | 7bb0e6765df42f955a2cd1a67ea55f06c643c10d /mysql-test/t | |
| parent | 25f9971aaac1d599856a3b3e1a2b5320b82c08b5 (diff) | |
| download | mariadb-git-1c459785127d40db78cf763f0e9e99e99693387c.tar.gz | |
Fix for bug #1564: CREATE TABLE + UNION + same table name = crash
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/union.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index ea7bdb4ee1b..ba4673e9a88 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -223,4 +223,7 @@ SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a desc LIMIT 1; --error 1234 (SELECT * FROM t1) UNION all (SELECT SQL_CALC_FOUND_ROWS * FROM t2) LIMIT 1; +create temporary table t1 select a from t1 union select a from t2; +--error 1093 +create table t1 select a from t1 union select a from t2; drop table t1,t2; |