diff options
| author | unknown <mskold@mysql.com> | 2004-08-12 10:15:53 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-08-12 10:15:53 +0200 |
| commit | caa525d8ccda01cd8ef503a9697f51d67ea358e9 (patch) | |
| tree | bdb7093cac07cfb9e679919122f1c9487b5349e9 /mysql-test/t/ndb_alter_table.test | |
| parent | 00c547d3abc82e2d5bc002ce632d698e1ed6cf50 (diff) | |
| download | mariadb-git-caa525d8ccda01cd8ef503a9697f51d67ea358e9.tar.gz | |
Added tests for fix of bug#4730
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
| -rw-r--r-- | mysql-test/t/ndb_alter_table.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index 1d7220da8bb..ffcd0b99745 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -30,8 +30,10 @@ col3 varchar (20) not null, col4 varchar(4) not null, col5 enum('PENDING', 'ACTIVE', 'DISABLED') not null, col6 int not null, to_be_deleted int) ENGINE=ndbcluster; +show table status; insert into t1 values (0,4,3,5,"PENDING",1,7),(NULL,4,3,5,"PENDING",1,7),(31,4,3,5,"PENDING",1,7), (7,4,3,5,"PENDING",1,7), (NULL,4,3,5,"PENDING",1,7), (100,4,3,5,"PENDING",1,7), (99,4,3,5,"PENDING",1,7), (8,4,3,5,"PENDING",1,7), (NULL,4,3,5,"PENDING",1,7); +show table status; select * from t1 order by col1; alter table t1 add column col4_5 varchar(20) not null after col4, @@ -39,8 +41,10 @@ add column col7 varchar(30) not null after col5, add column col8 datetime not null, drop column to_be_deleted, change column col2 fourth varchar(30) not null after col3, modify column col6 int not null first; +show table status; select * from t1 order by col1; insert into t1 values (2, NULL,4,3,5,99,"PENDING","EXTRA",'2004-01-01 00:00:00'); +show table status; select * from t1 order by col1; drop table t1; |