~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create_select_tmp.result

  • Committer: Brian Aker
  • Date: 2009-06-16 00:53:22 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: brian@gaz-20090616005322-w0ode4jul9z8s2y9
Partial fix for tests for tmp

Show diffs side-by-side

added added

removed removed

Lines of Context:
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