heap.heap_auto_increment                 w3 [ fail ]

        Test ended at 2018-06-30 12:42:55

CURRENT_TEST: heap.heap_auto_increment

mysqltest: In included file "./include/autoinc_mdev15353.inc": 

included from /usr/share/mysql/mysql-test/suite/heap/heap_auto_increment.test at line 43:

At line 21: query 'CALL autoinc_mdev15353_one(@engine, 'tinyint')' failed: 167: Out of range value for column 'id' at row 1

The result from queries just before the failure was:

< snip >

#

SET @engine='MEMORY';

CREATE PROCEDURE autoinc_mdev15353_one(engine VARCHAR(64), t VARCHAR(64))

BEGIN

DECLARE query TEXT DEFAULT 'CREATE TABLE t1 ('

                             '  id TTT NOT NULL AUTO_INCREMENT,'

                             '  name CHAR(30) NOT NULL,'

                             '  PRIMARY KEY (id)) ENGINE=EEE';

EXECUTE IMMEDIATE REPLACE(REPLACE(query,'TTT', t), 'EEE', engine);

SHOW CREATE TABLE t1;

INSERT INTO t1 (name) VALUES ('dog');

SELECT * FROM t1;

UPDATE t1 SET id=-1 WHERE id=1;

SELECT * FROM t1;

INSERT INTO t1 (name) VALUES ('cat');

SELECT * FROM t1;

DROP TABLE t1;

END;

$$

CALL autoinc_mdev15353_one(@engine, 'tinyint');

More results from queries before failure can be found in /dev/shm/var/3/log/heap_auto_increment.log

Warnings from just before the error:

Error 167 Out of range value for column 'id' at row 1