summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_alter_table.test
diff options
context:
space:
mode:
authorunknown <tomas@poseidon.ndb.mysql.com>2004-10-07 16:30:21 +0000
committerunknown <tomas@poseidon.ndb.mysql.com>2004-10-07 16:30:21 +0000
commit1b991b1a405c7c458ac3c22c88174a71fb830705 (patch)
treef850ebcc2d756983674a842012c49e1d66c6126d /mysql-test/t/ndb_alter_table.test
parentc2d6d2c04b0d6ce621fc427ae51e58d721da50f3 (diff)
downloadmariadb-git-1b991b1a405c7c458ac3c22c88174a71fb830705.tar.gz
ndb_alter_table.result, ndb_alter_table.test:
... mysql-test/t/ndb_alter_table.test: ... mysql-test/r/ndb_alter_table.result: ...
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
-rw-r--r--mysql-test/t/ndb_alter_table.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test
index 1c1ef670af2..22b1a0e476d 100644
--- a/mysql-test/t/ndb_alter_table.test
+++ b/mysql-test/t/ndb_alter_table.test
@@ -95,7 +95,9 @@ CREATE TABLE t1 (
INSERT INTO t1 VALUES (0,1),(17,18);
select * from t1 order by a;
+SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO;
alter table t1 modify column a int not null auto_increment;
+SET SQL_MODE='';
select * from t1 order by a;
INSERT INTO t1 VALUES (0,19),(20,21);
select * from t1 order by a;