diff options
| author | unknown <mskold@mysql.com> | 2004-09-15 18:44:18 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-09-15 18:44:18 +0200 |
| commit | f955763fb368e592f807e0953be89a575228df5f (patch) | |
| tree | f0d49fcef25f532565ed98d9b2a69b6d5537fcbe /mysql-test/t/ndb_alter_table.test | |
| parent | 00fa471d5a711d8702a2c840568c6b31122adde9 (diff) | |
| download | mariadb-git-f955763fb368e592f807e0953be89a575228df5f.tar.gz | |
Fixed handling of NO_AUTO_VALUE_ON_ZERO
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
| -rw-r--r-- | mysql-test/t/ndb_alter_table.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index f3b1de6f1e6..3cdddfa8dce 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -31,6 +31,7 @@ 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; +SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO; 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; |