summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-07-16 03:07:45 +0300
committerunknown <monty@tik.mysql.fi>2001-07-16 03:07:45 +0300
commitfb1b1ba26b69b1c2767bb5a3b676a8edff529e56 (patch)
treef28a764d2729df5d2de75f9f4fb6ace491d14245 /mysql-test
parentef63cbc810321573d9ab86e243e9e5b645572bc3 (diff)
parent2a18a762e1d4c688ff169e92a8c3977bcbb00f03 (diff)
downloadmariadb-git-fb1b1ba26b69b1c2767bb5a3b676a8edff529e56.tar.gz
Merge
Docs/manual.texi: SCCS merged
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/auto_increment.result5
-rw-r--r--mysql-test/r/limit.result3
-rw-r--r--mysql-test/t/auto_increment.test11
-rw-r--r--mysql-test/t/limit.test11
4 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result
index 9ff02d7a7b8..bf6265e5b64 100644
--- a/mysql-test/r/auto_increment.result
+++ b/mysql-test/r/auto_increment.result
@@ -55,3 +55,8 @@ ordid ord
2 sdj
3 sdj
1 zzz
+a
+0
+Table Op Msg_type Msg_text
+test.t1 check warning Found row where the auto_increment column has the value 0
+test.t1 check status OK
diff --git a/mysql-test/r/limit.result b/mysql-test/r/limit.result
index 0f5586e3b31..6c3a1ed17e4 100644
--- a/mysql-test/r/limit.result
+++ b/mysql-test/r/limit.result
@@ -20,3 +20,6 @@ a b
a b
2 2
3 4
+i
+2
+1
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;
diff --git a/mysql-test/t/limit.test b/mysql-test/t/limit.test
index ba075f73d37..112761abd87 100644
--- a/mysql-test/t/limit.test
+++ b/mysql-test/t/limit.test
@@ -17,3 +17,14 @@ select * from t1;
delete from t1 limit 1;
select * from t1;
drop table t1;
+
+create table t1 (i int);
+insert into t1 (i) values(1);
+insert into t1 (i) values(1);
+insert into t1 (i) values(1);
+delete from t1 limit 1;
+update t1 set i=2 limit 1;
+delete from t1 limit 0;
+update t1 set i=3 limit 0;
+select * from t1;
+drop table t1;