summaryrefslogtreecommitdiff
path: root/mysql-test/t/auto_increment.test
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-07-16 03:04:30 +0300
committerunknown <monty@tik.mysql.fi>2001-07-16 03:04:30 +0300
commit2a18a762e1d4c688ff169e92a8c3977bcbb00f03 (patch)
tree12ce618a9c1f4bb3a79632d66e11232e84ab2e12 /mysql-test/t/auto_increment.test
parentcb696ba1f3f7d64dbedd64487c7d02660251f98f (diff)
downloadmariadb-git-2a18a762e1d4c688ff169e92a8c3977bcbb00f03.tar.gz
Patch for netBSD
Added warning for tables where the auto_increment key is 0 Fixed DELETE ... LIMIT 0 Fixed UPDATE ..LIMIT 0 Docs/manual.texi: Changelog + Update to CHECK TABLE configure.in: Patch for netBSD mit-pthreads/gen/ctime.c: Patch for netBSD mit-pthreads/machdep/netbsd-1.1/__signal.h: Patch for netBSD mit-pthreads/stdio/strerror.c: Patch for netBSD myisam/mi_check.c: Added warning for tables where the auto_increment key is 0 myisam/myisamchk.c: Added warning for tables where the auto_increment key is 0 mysql-test/r/auto_increment.result: Added warning for tables where the auto_increment key is 0 mysql-test/r/limit.result: Test of DELETE ... LIMIT 0 mysql-test/t/auto_increment.test: Added warning for tables where the auto_increment key is 0 mysql-test/t/limit.test: Test of DELETE ... LIMIT 0 sql/Makefile.am: Don't add mysqld_LDADD to mysqlbinlog (portability patch) sql/ha_gemini.cc: Changed copyright (have got ok from NuSphere previously) sql/ha_gemini.h: Changed copyright (have got ok from NuSphere previously) sql/sql_delete.cc: Fixed DELETE ... LIMIT 0 sql/sql_update.cc: Fixed UPDATE ..LIMIT 0
Diffstat (limited to 'mysql-test/t/auto_increment.test')
-rw-r--r--mysql-test/t/auto_increment.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test
index 1741b51b2d6..b9b8c244699 100644
--- a/mysql-test/t/auto_increment.test
+++ b/mysql-test/t/auto_increment.test
@@ -64,3 +64,14 @@ create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null
insert into t1 values (NULL,'sdj'),(NULL,'sdj'),(NULL,"abc"),(NULL,'abc'),(NULL,'zzz'),(NULL,'sdj'),(NULL,'abc');
select * from t1;
drop table t1;
+
+#
+# Test of auto_increment columns when they are set to 0
+#
+
+create table t1 (a int not null primary key auto_increment);
+insert into t1 values (0);
+update t1 set a=0;
+select * from t1;
+check table t1;
+drop table t1;