478
478
DROP TABLE t1, t2;
480
# Bug#39828 autoinc wraps around when offset and increment > 1
482
CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) engine=MyISAM;
483
INSERT INTO t1 VALUES(1);
484
INSERT INTO t1 VALUES (18446744073709551601);
485
SET @@SESSION.AUTO_INCREMENT_INCREMENT=10;
486
SELECT @@SESSION.AUTO_INCREMENT_OFFSET;
487
@@SESSION.AUTO_INCREMENT_OFFSET
489
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
490
ERROR 22003: Out of range value for column 't1' at row 167
496
SET @@SESSION.AUTO_INCREMENT_INCREMENT=default;
497
SET @@SESSION.AUTO_INCREMENT_OFFSET=default;
501
# Bug#50619 assert in handler::update_auto_increment
503
CREATE TABLE t1 (pk INT AUTO_INCREMENT, PRIMARY KEY (pk));
504
INSERT INTO t1 VALUES (NULL), (-1), (NULL);
511
CREATE TABLE t1 (pk BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (pk));
512
INSERT INTO t1 VALUES (NULL), (18446744073709551615-1), (NULL);
513
ERROR HY000: Failed to read auto-increment value from storage engine