← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/create.test

  • Committer: Andrew Hutchings
  • Date: 2011-02-07 17:20:59 UTC
  • mfrom: (2148 staging)
  • mto: (2148.2.3 build)
  • mto: This revision was merged to the branch mainline in revision 2149.
  • Revision ID: andrew@linuxjedi.co.uk-20110207172059-dyeahrgzrlincoe3
Merge with trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/create.test
26
26
# Test of some CREATE TABLE'S that should fail
27
27
#
28
28
 
29
 
--error ER_NO_SUCH_TABLE
 
29
--error ER_TABLE_UNKNOWN
30
30
create temporary table t2 engine=MEMORY select * from t1;
31
 
--error ER_NO_SUCH_TABLE
 
31
--error ER_TABLE_UNKNOWN
32
32
create table t2 select auto+1 from t1;
33
33
drop table if exists t1,t2;
34
34
--error ER_WRONG_KEY_COLUMN
162
162
INSERT INTO t1 values (1),(2),(1);
163
163
--error ER_DUP_ENTRY
164
164
CREATE TABLE t2 (primary key(a)) SELECT * FROM t1;
165
 
--error ER_NO_SUCH_TABLE
 
165
--error ER_TABLE_UNKNOWN
166
166
SELECT * from t2;
167
167
DROP TABLE t1;
168
168
DROP TABLE IF EXISTS t2;
664
664
#  of error it is automatically dropped if it has not existed before.)
665
665
#
666
666
# Error during open_and_lock_tables() of tables
667
 
--error ER_NO_SUCH_TABLE
 
667
--error ER_TABLE_UNKNOWN
668
668
create table t1 select * from t2;
669
669
# Rather special error which also caught during open tables pahse
670
670
--error ER_UPDATE_TABLE_USED
715
715
create table if not exists t1 select 1;
716
716
select * from t1;
717
717
drop temporary table t1;
718
 
--error ER_NO_SUCH_TABLE
 
718
--error ER_TABLE_UNKNOWN
719
719
select * from t1;
720
720
--error ER_BAD_TABLE_ERROR
721
721
drop table t1;