343
343
DROP TABLE t1, t2;
346
--echo # Bug#39828 autoinc wraps around when offset and increment > 1
349
CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) engine=MyISAM;
350
INSERT INTO t1 VALUES(1);
351
INSERT INTO t1 VALUES (18446744073709551601);
353
SET @@SESSION.AUTO_INCREMENT_INCREMENT=10;
355
SELECT @@SESSION.AUTO_INCREMENT_OFFSET;
356
--error ER_WARN_DATA_OUT_OF_RANGE
357
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
360
SET @@SESSION.AUTO_INCREMENT_INCREMENT=default;
361
SET @@SESSION.AUTO_INCREMENT_OFFSET=default;
365
--echo End of 5.1 tests
368
--echo # Bug#50619 assert in handler::update_auto_increment
371
CREATE TABLE t1 (pk INT AUTO_INCREMENT, PRIMARY KEY (pk));
372
# This triggered the assert
373
INSERT INTO t1 VALUES (NULL), (-1), (NULL);
377
# Check that that true overflow still gives error
378
CREATE TABLE t1 (pk BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (pk));
379
--error ER_AUTOINC_READ_FAILED
380
INSERT INTO t1 VALUES (NULL), (18446744073709551615-1), (NULL);