summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb-autoinc.result
diff options
context:
space:
mode:
authorTimothy Smith <timothy.smith@sun.com>2008-12-19 01:28:51 +0100
committerTimothy Smith <timothy.smith@sun.com>2008-12-19 01:28:51 +0100
commit3f85c7f2702f1b25fcb9ea734d716bf9c885925e (patch)
treea916fdd5468c7677e9fc87ed72b81acb661459ce /mysql-test/r/innodb-autoinc.result
parent22d47a6c3699eea095c7a67e205b1aa637d340ef (diff)
downloadmariadb-git-3f85c7f2702f1b25fcb9ea734d716bf9c885925e.tar.gz
Disable part of innodb-autoinc.test, because the MySQL server asserts when
compiled --with-debug, due to bug 39828, "autoinc wraps around when offset and increment > 1". This change should be reverted when that bug is fixed (and a a few other minor changes to the test as described in comments).
Diffstat (limited to 'mysql-test/r/innodb-autoinc.result')
-rw-r--r--mysql-test/r/innodb-autoinc.result12
1 files changed, 5 insertions, 7 deletions
diff --git a/mysql-test/r/innodb-autoinc.result b/mysql-test/r/innodb-autoinc.result
index 589bf2f30b0..1e4b088c6cd 100644
--- a/mysql-test/r/innodb-autoinc.result
+++ b/mysql-test/r/innodb-autoinc.result
@@ -471,10 +471,9 @@ SHOW VARIABLES LIKE "%auto_inc%";
Variable_name Value
auto_increment_increment 2
auto_increment_offset 10
-INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
+INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
SELECT * FROM t1;
c1
-0
1
18446744073709551603
18446744073709551604
@@ -505,12 +504,13 @@ SHOW VARIABLES LIKE "%auto_inc%";
Variable_name Value
auto_increment_increment 5
auto_increment_offset 7
-INSERT INTO t1 VALUES (NULL),(NULL), (NULL);
-Got one of the listed errors
+INSERT INTO t1 VALUES (NULL),(NULL);
SELECT * FROM t1;
c1
1
18446744073709551603
+18446744073709551607
+18446744073709551612
DROP TABLE t1;
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
SET @@INSERT_ID=1;
@@ -572,12 +572,10 @@ SHOW VARIABLES LIKE "%auto_inc%";
Variable_name Value
auto_increment_increment 65535
auto_increment_offset 65535
-INSERT INTO t1 VALUES (NULL),(NULL), (NULL);
+INSERT INTO t1 VALUES (NULL);
SELECT * FROM t1;
c1
1
-65534
-65535
18446744073709551610
18446744073709551615
DROP TABLE t1;