summaryrefslogtreecommitdiff
path: root/mysql-test/t/create_select_tmp.test
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-09-01 17:15:37 +0200
committerunknown <msvensson@neptunus.(none)>2005-09-01 17:15:37 +0200
commit4fed17727655091622b0244c9a127010cab719a9 (patch)
tree80ada8364981cc5d65dec53d473583b35d07abe6 /mysql-test/t/create_select_tmp.test
parentf5db9c9a5be0f2f7f78229e2b6054aae3d940c1c (diff)
parente2965fb2628c9d4e557d755eeca0bc24b43fb353 (diff)
downloadmariadb-git-4fed17727655091622b0244c9a127010cab719a9.tar.gz
Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0
into neptunus.(none):/home/msvensson/mysql/bug11316/my50-bug11316 mysql-test/mysql-test-run.pl: Auto merged mysql-test/mysql-test-run.sh: Auto merged mysql-test/r/mysqltest.result: Auto merged mysql-test/r/type_newdecimal.result: Auto merged mysql-test/t/create.test: Auto merged mysql-test/t/create_select_tmp.test: Auto merged mysql-test/t/drop.test: Auto merged mysql-test/t/flush.test: Auto merged mysql-test/t/handler.test: Auto merged mysql-test/t/innodb-deadlock.test: Auto merged mysql-test/t/innodb-lock.test: Auto merged mysql-test/t/innodb.test: Auto merged mysql-test/t/kill.test: Auto merged mysql-test/t/ndb_autodiscover2.test: Auto merged mysql-test/t/rpl000001.test: Auto merged mysql-test/t/rpl_EE_error.test: Auto merged mysql-test/t/rpl_change_master.test: Auto merged mysql-test/t/rpl_deadlock.test: Auto merged mysql-test/t/rpl_drop.test: Auto merged mysql-test/t/rpl_drop_temp.test: Auto merged mysql-test/t/rpl_error_ignored_table.test: Auto merged mysql-test/t/rpl_flush_log_loop.test: Auto merged mysql-test/t/rpl_insert_id.test: Auto merged mysql-test/t/rpl_loaddata.test: Auto merged mysql-test/t/rpl_rotate_logs.test: Auto merged mysql-test/t/rpl_sp.test: Auto merged mysql-test/t/rpl_until.test: Auto merged mysql-test/t/strict.test: Auto merged mysql-test/t/type_newdecimal.test: Auto merged client/mysqltest.c: Merge with --parsing-disabled mysql-test/t/mysqltest.test: Manual merge
Diffstat (limited to 'mysql-test/t/create_select_tmp.test')
-rw-r--r--mysql-test/t/create_select_tmp.test16
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/t/create_select_tmp.test b/mysql-test/t/create_select_tmp.test
index 2e4c0f22997..1661a115f72 100644
--- a/mysql-test/t/create_select_tmp.test
+++ b/mysql-test/t/create_select_tmp.test
@@ -11,21 +11,21 @@ drop table if exists t1, t2;
--enable_warnings
CREATE TABLE t1 ( a int );
INSERT INTO t1 VALUES (1),(2),(1);
---error 1062;
+--error 1062
CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
---error 1146;
+--error 1146
select * from t2;
---error 1062;
+--error 1062
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
---error 1146;
+--error 1146
select * from t2;
---error 1062;
+--error 1062
CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
---error 1146;
+--error 1146
select * from t2;
---error 1062;
+--error 1062
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
---error 1146;
+--error 1146
select * from t2;
# End of 4.1 tests