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/t/auto_increment.test | |
| parent | 8394b6a2713ff0823448aa62eea1251bfb2f9e03 (diff) | |
| parent | 1faf910eeb4e8f40253bf34b634af5332f367dc5 (diff) | |
| download | mariadb-git-e52e64ac35670a7359b16bff5c0073aa13d3abc3.tar.gz | |
5.1-bugteam->5.5-bugteam merge
Diffstat (limited to 'mysql-test/t/auto_increment.test')
| -rw-r--r-- | mysql-test/t/auto_increment.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index 42751b8ce06..9da8c759d45 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -342,3 +342,24 @@ SELECT a FROM t2; DROP TABLE t1, t2; +--echo # +--echo # Bug#39828 autoinc wraps around when offset and increment > 1 +--echo # + +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; +--error ER_WARN_DATA_OUT_OF_RANGE +INSERT INTO t1 VALUES (NULL), (NULL), (NULL); +SELECT * FROM t1; + +SET @@SESSION.AUTO_INCREMENT_INCREMENT=default; +SET @@SESSION.AUTO_INCREMENT_OFFSET=default; + +DROP TABLE t1; + +--echo End of 5.1 tests |