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/r/auto_increment.result | |
| 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/r/auto_increment.result')
| -rw-r--r-- | mysql-test/r/auto_increment.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result index 5adbefe104c..d21e78428c5 100644 --- a/mysql-test/r/auto_increment.result +++ b/mysql-test/r/auto_increment.result @@ -497,3 +497,22 @@ SET @@SESSION.AUTO_INCREMENT_INCREMENT=default; SET @@SESSION.AUTO_INCREMENT_OFFSET=default; DROP TABLE t1; End of 5.1 tests +# +# Bug#50619 assert in handler::update_auto_increment +# +CREATE TABLE t1 (pk INT AUTO_INCREMENT, PRIMARY KEY (pk)); +INSERT INTO t1 VALUES (NULL), (-1), (NULL); +SELECT * FROM t1; +pk +-1 +1 +2 +DROP TABLE t1; +CREATE TABLE t1 (pk BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (pk)); +INSERT INTO t1 VALUES (NULL), (18446744073709551615-1), (NULL); +ERROR HY000: Failed to read auto-increment value from storage engine +SELECT * FROM t1; +pk +1 +18446744073709551614 +DROP TABLE t1; |