From a209e293f07f6c5504974003c2224b5ca979726d Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 8 Apr 2005 11:38:40 +0200 Subject: Added more tests for auto_increment --- mysql-test/r/ndb_basic.result | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) (limited to 'mysql-test/r/ndb_basic.result') 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; -- cgit v1.2.1