diff options
Diffstat (limited to 'mysql-test/r/create_select_tmp.result')
| -rw-r--r-- | mysql-test/r/create_select_tmp.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/create_select_tmp.result b/mysql-test/r/create_select_tmp.result index 610ee70b3e3..09ffc9013c7 100644 --- a/mysql-test/r/create_select_tmp.result +++ b/mysql-test/r/create_select_tmp.result @@ -2,18 +2,18 @@ drop table if exists t1, t2; CREATE TABLE t1 ( a int ); INSERT INTO t1 VALUES (1),(2),(1); CREATE TABLE t2 ( PRIMARY KEY (a) ) TYPE=INNODB SELECT a FROM t1; -Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 1 select * from t2; -Table 'test.t2' doesn't exist +ERROR 42S02: Table 'test.t2' doesn't exist CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) TYPE=INNODB SELECT a FROM t1; -Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 1 select * from t2; -Table 'test.t2' doesn't exist +ERROR 42S02: Table 'test.t2' doesn't exist CREATE TABLE t2 ( PRIMARY KEY (a) ) TYPE=MYISAM SELECT a FROM t1; -Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 1 select * from t2; -Table 'test.t2' doesn't exist +ERROR 42S02: Table 'test.t2' doesn't exist CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) TYPE=MYISAM SELECT a FROM t1; -Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 1 select * from t2; -Table 'test.t2' doesn't exist +ERROR 42S02: Table 'test.t2' doesn't exist |