From bf9876a195414ab8a5e2e1a56c5b041d807d926b Mon Sep 17 00:00:00 2001
From: "monty@tik.mysql.fi" <>
Date: Mon, 16 Jul 2001 03:04:30 +0300
Subject: Patch for netBSD Added warning for tables where the auto_increment
 key is 0 Fixed DELETE ... LIMIT 0 Fixed UPDATE ..LIMIT 0

---
 mysql-test/t/auto_increment.test | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'mysql-test/t/auto_increment.test')

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;
-- 
cgit v1.2.1