~drizzle-pbxt/drizzle/drizzle-pbxt-2

« back to all changes in this revision

Viewing changes to tests/r/create_select_tmp.result

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

Show diffs side-by-side

added

removed

tests/r/create_select_tmp.result

17

17

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

18

18

select * from t2;

19

19

ERROR 42S02: Table 'test.t2' doesn't exist

20

 

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

 

20

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

21

21

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

22

22

select * from t2;

23

23

ERROR 42S02: Table 'test.t2' doesn't exist

• Older »

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