summaryrefslogtreecommitdiff
path: root/mysql-test/r/union.result
diff options
context:
space:
mode:
authorunknown <gluh@gluh.mysql.r18.ru>2003-11-11 18:14:49 +0400
committerunknown <gluh@gluh.mysql.r18.ru>2003-11-11 18:14:49 +0400
commit1c459785127d40db78cf763f0e9e99e99693387c (patch)
tree7bb0e6765df42f955a2cd1a67ea55f06c643c10d /mysql-test/r/union.result
parent25f9971aaac1d599856a3b3e1a2b5320b82c08b5 (diff)
downloadmariadb-git-1c459785127d40db78cf763f0e9e99e99693387c.tar.gz
Fix for bug #1564: CREATE TABLE + UNION + same table name = crash
Diffstat (limited to 'mysql-test/r/union.result')
-rw-r--r--mysql-test/r/union.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result
index 9899b8279e2..cd5d600edf4 100644
--- a/mysql-test/r/union.result
+++ b/mysql-test/r/union.result
@@ -419,4 +419,7 @@ a
3
(SELECT * FROM t1) UNION all (SELECT SQL_CALC_FOUND_ROWS * FROM t2) LIMIT 1;
Wrong usage/placement of 'SQL_CALC_FOUND_ROWS'
+create temporary table t1 select a from t1 union select a from t2;
+create table t1 select a from t1 union select a from t2;
+INSERT TABLE 't1' isn't allowed in FROM table list
drop table t1,t2;