~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create_select_tmp.result

• browse files at revision 751
• compare with another revision
• compare with revision 1819.5.262
• download diff
• download tarball
• view history from revision 751

Show diffs side-by-side

added

removed

tests/r/create_select_tmp.result

1

1

drop table if exists t1, t2;

2

 

CREATE TABLE t1 ( a int );

 

2

Warnings:

 

3

Note    1051    Unknown table 't1'

 

4

Note    1051    Unknown table 't2'

 

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;

3

11

INSERT INTO t1 VALUES (1),(2),(1);

4

12

CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;

5

13

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1