|
1
by brian
clean slate |
1 |
drop table if exists t1, t2;
|
|
722.2.28
by Monty Taylor
Removed some silliness. |
2 |
Warnings:
|
3 |
Note 1051 Unknown table 't1'
|
|
4 |
Note 1051 Unknown table 't2'
|
|
|
722.2.29
by Monty Taylor
Fixed create_select_tmp test. |
5 |
drop table if exists t1;
|
6 |
Warnings:
|
|
7 |
Note 1051 Unknown table 't1'
|
|
8 |
CREATE TABLE t1 (
|
|
9 |
a int DEFAULT 0 NOT NULL
|
|
10 |
) ENGINE = InnoDB;
|
|
|
1
by brian
clean slate |
11 |
INSERT INTO t1 VALUES (1),(2),(1);
|
12 |
CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
|
|
13 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
14 |
select * from t2;
|
|
15 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
16 |
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
|
|
17 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
18 |
select * from t2;
|
|
19 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
|
1063.9.3
by Brian Aker
Partial fix for tests for tmp |
20 |
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
|
|
1
by brian
clean slate |
21 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
22 |
select * from t2;
|
|
23 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
24 |
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
|
|
25 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
26 |
select * from t2;
|
|
27 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
28 |
drop table t1;
|