diff options
| author | unknown <mskold@mysql.com> | 2004-08-10 14:38:24 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-08-10 14:38:24 +0200 |
| commit | 89017ca5b02a5329be2bcba8e06b5d86bfce39e1 (patch) | |
| tree | 1280f443cadc45593c65192a07e4989ef17085ef /mysql-test/t/ndb_alter_table.test | |
| parent | 04cc2cc4d12b973c533cd35a6050932f82fb4ca3 (diff) | |
| download | mariadb-git-89017ca5b02a5329be2bcba8e06b5d86bfce39e1.tar.gz | |
Bug fix for bug#3912
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
| -rw-r--r-- | mysql-test/t/ndb_alter_table.test | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index 52b35146f5c..1d7220da8bb 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -29,8 +29,9 @@ col2 varchar(30) not null, 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; -insert into t1 values (2,4,3,5,"PENDING",1,7), (NULL,4,3,5,"PENDING",1,7), (25, 4,3,5,"PENDING",1,7), (NULL,4,3,5,"PENDING",1,7); +col6 int not null, to_be_deleted int) ENGINE=ndbcluster; +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); select * from t1 order by col1; alter table t1 add column col4_5 varchar(20) not null after col4, |