~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_table_build_method.result

  • Committer: Stewart Smith
  • Date: 2011-03-01 10:59:43 UTC
  • mto: (2241.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 2242.
  • Revision ID: stewart@flamingspork.com-20110301105943-3j0bha31q868fh4e
throw an error if ONLINE ALTER TABLE is asked for that we cannot do without a copying alter table.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
CREATE TABLE t1 (a int);
 
2
ALTER ONLINE TABLE t1 RENAME t2;
 
3
ALTER ONLINE TABLE t2 RENAME t1;
 
4
ALTER ONLINE TABLE t1 add column b int;
 
5
ERROR 42000: This version of Drizzle doesn't yet support 'ALTER ONLINE TABLE t1 add column b int'
 
6
ALTER OFFLINE TABLE t1 add column c int;
 
7
DROP TABLE t1;