~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/csv_alter_table.test

  • Committer: devananda
  • Date: 2009-06-30 14:27:54 UTC
  • mfrom: (1030.2.4 trunk)
  • mto: (1093.1.7 captain)
  • mto: This revision was merged to the branch mainline in revision 1095.
  • Revision ID: devananda.vdv@gmail.com-20090630142754-vm9w374yxkf1pikc
mergeĀ fromĀ lp

Show diffs side-by-side

added added

removed removed

Lines of Context:
21
21
DROP TABLE IF EXISTS t1;
22
22
--enable_warnings
23
23
 
24
 
CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
 
24
CREATE TEMPORARY TABLE t1 (a int NOT NULL) ENGINE = CSV;
25
25
ALTER TABLE t1 ADD COLUMN b CHAR(5) NOT NULL;
26
26
DESC t1;
27
27
ALTER TABLE t1 DROP COLUMN b;
40
40
-- echo # ===== csv_alter_table.2 =====
41
41
DROP TABLE IF EXISTS t1;
42
42
 
43
 
CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
 
43
CREATE TEMPORARY TABLE t1 (a int NOT NULL) ENGINE = CSV;
44
44
--error ER_CHECK_NOT_IMPLEMENTED
45
45
ALTER TABLE t1 ADD COLUMN b CHAR(5);
46
46
DESC t1;