diff options
| author | Sergey Glukhov <sergey.glukhov@oracle.com> | 2010-12-13 15:11:16 +0300 |
|---|---|---|
| committer | Sergey Glukhov <sergey.glukhov@oracle.com> | 2010-12-13 15:11:16 +0300 |
| commit | e52e64ac35670a7359b16bff5c0073aa13d3abc3 (patch) | |
| tree | a593fa4030c4a1f54c1869a03d249138e310744c /mysql-test/r/auto_increment.result | |
| parent | 8394b6a2713ff0823448aa62eea1251bfb2f9e03 (diff) | |
| parent | 1faf910eeb4e8f40253bf34b634af5332f367dc5 (diff) | |
| download | mariadb-git-e52e64ac35670a7359b16bff5c0073aa13d3abc3.tar.gz | |
5.1-bugteam->5.5-bugteam merge
Diffstat (limited to 'mysql-test/r/auto_increment.result')
| -rw-r--r-- | mysql-test/r/auto_increment.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index dbeedb481cd..5adbefe104c 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -476,3 +476,24 @@ SELECT a FROM t2; a 2 DROP TABLE t1, t2; +# +# Bug#39828 autoinc wraps around when offset and increment > 1 +# +CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) engine=MyISAM; +INSERT INTO t1 VALUES(1); +INSERT INTO t1 VALUES (18446744073709551601); +SET @@SESSION.AUTO_INCREMENT_INCREMENT=10; +SELECT @@SESSION.AUTO_INCREMENT_OFFSET; +@@SESSION.AUTO_INCREMENT_OFFSET +1 +INSERT INTO t1 VALUES (NULL), (NULL), (NULL); +ERROR 22003: Out of range value for column 't1' at row 167 +SELECT * FROM t1; +c1 +1 +18446744073709551601 +18446744073709551611 +SET @@SESSION.AUTO_INCREMENT_INCREMENT=default; +SET @@SESSION.AUTO_INCREMENT_OFFSET=default; +DROP TABLE t1; +End of 5.1 tests |