diff options
| author | Jon Olav Hauglid <jon.hauglid@oracle.com> | 2011-01-04 15:28:03 +0100 |
|---|---|---|
| committer | Jon Olav Hauglid <jon.hauglid@oracle.com> | 2011-01-04 15:28:03 +0100 |
| commit | db2234b95ba9ca6aded84ced39872155d33a8984 (patch) | |
| tree | 0952825961a73897901d0b51a98663cbc7684c0b /mysql-test/t/auto_increment.test | |
| parent | ee46dc0f23e45104071b35ff18b9ea5a20a23a2a (diff) | |
| parent | 405ac384f54c58bc207f257a7bf6cfe2bb7b1445 (diff) | |
| download | mariadb-git-db2234b95ba9ca6aded84ced39872155d33a8984.tar.gz | |
Merge from mysql-5.1 to mysql-5.5.
No conflicts.
Diffstat (limited to 'mysql-test/t/auto_increment.test')
| -rw-r--r-- | mysql-test/t/auto_increment.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index 9da8c759d45..2854f503034 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -363,3 +363,20 @@ SET @@SESSION.AUTO_INCREMENT_OFFSET=default; DROP TABLE t1; --echo End of 5.1 tests + +--echo # +--echo # Bug#50619 assert in handler::update_auto_increment +--echo # + +CREATE TABLE t1 (pk INT AUTO_INCREMENT, PRIMARY KEY (pk)); +# This triggered the assert +INSERT INTO t1 VALUES (NULL), (-1), (NULL); +SELECT * FROM t1; +DROP TABLE t1; + +# Check that that true overflow still gives error +CREATE TABLE t1 (pk BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (pk)); +--error ER_AUTOINC_READ_FAILED +INSERT INTO t1 VALUES (NULL), (18446744073709551615-1), (NULL); +SELECT * FROM t1; +DROP TABLE t1; |