← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/csv/tests/t/csv_alter_table.test

  • Committer: Monty Taylor
  • Date: 2010-03-11 18:27:20 UTC
  • mfrom: (1333 staging)
  • mto: This revision was merged to the branch mainline in revision 1348.
  • Revision ID: mordred@inaugust.com-20100311182720-hd1h87y6cb1b1mp0
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/csv/tests/t/csv_alter_table.test
21
21
 
22
22
CREATE TEMPORARY TABLE t1 (a int NOT NULL) ENGINE = CSV;
23
23
ALTER TABLE t1 ADD COLUMN b CHAR(5) NOT NULL;
24
 
DESC t1;
 
24
#DESC t1;
25
25
ALTER TABLE t1 DROP COLUMN b;
26
 
DESC t1;
 
26
#DESC t1;
27
27
ALTER TABLE t1 MODIFY a BIGINT NOT NULL;
28
 
DESC t1;
 
28
#DESC t1;
29
29
ALTER TABLE t1 CHANGE a a INT NOT NULL;
30
 
DESC t1;
 
30
#DESC t1;
31
31
 
32
32
DROP TABLE t1;
33
33
 
41
41
CREATE TEMPORARY TABLE t1 (a int NOT NULL) ENGINE = CSV;
42
42
--error ER_CHECK_NOT_IMPLEMENTED
43
43
ALTER TABLE t1 ADD COLUMN b CHAR(5);
44
 
DESC t1;
 
44
#DESC t1;
45
45
--error ER_CHECK_NOT_IMPLEMENTED
46
46
ALTER TABLE t1 MODIFY a BIGINT;
47
 
DESC t1;
 
47
#DESC t1;
48
48
--error ER_CHECK_NOT_IMPLEMENTED
49
49
ALTER TABLE t1 CHANGE a a INT;
50
 
DESC t1;
 
50
#DESC t1;
51
51
 
52
52
DROP TABLE t1;