From 61fed028ba5278a5c9184d5a752ce021456601d5 Mon Sep 17 00:00:00 2001
From: unknown <mskold@mysql.com>
Date: Fri, 8 Apr 2005 11:38:40 +0200
Subject: Added more tests for auto_increment

---
 mysql-test/r/ndb_basic.result | 30 ++++++++++++++++++++++++++++++
 mysql-test/t/ndb_basic.test   |  2 ++
 2 files changed, 32 insertions(+)

(limited to 'mysql-test')

diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result
index 12f9c3742e5..3712fa2b5ca 100644
--- a/mysql-test/r/ndb_basic.result
+++ b/mysql-test/r/ndb_basic.result
@@ -619,12 +619,18 @@ counter	datavalue
 1	newval
 2	newval
 insert into t1 (datavalue) select datavalue from t1 where counter < 100;
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
 select * from t1 order by counter;
 counter	datavalue
 1	newval
 2	newval
 3	newval
 4	newval
+5	newval
+6	newval
+7	newval
+8	newval
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
 insert into t1 (datavalue) select datavalue from t1 where counter < 100;
 select * from t1 order by counter;
 counter	datavalue
@@ -632,8 +638,32 @@ counter	datavalue
 2	newval
 3	newval
 4	newval
+5	newval
+6	newval
+7	newval
+8	newval
 35	newval
 36	newval
 37	newval
 38	newval
+39	newval
+40	newval
+41	newval
+42	newval
+43	newval
+44	newval
+45	newval
+46	newval
+47	newval
+48	newval
+49	newval
+50	newval
+51	newval
+52	newval
+53	newval
+54	newval
+55	newval
+56	newval
+57	newval
+58	newval
 drop table t1;
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test
index 35e1ddc5ebf..66300f61fc3 100644
--- a/mysql-test/t/ndb_basic.test
+++ b/mysql-test/t/ndb_basic.test
@@ -596,9 +596,11 @@ insert into t1 (datavalue) values ('newval');
 insert into t1 (datavalue) values ('newval');
 select * from t1 order by counter;
 insert into t1 (datavalue) select datavalue from t1 where counter < 100;
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
 select * from t1 order by counter;
 connection con2;
 insert into t1 (datavalue) select datavalue from t1 where counter < 100;
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
 select * from t1 order by counter;
 
 drop table t1;
-- 
cgit v1.2.1