Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2(EOL), 10.3(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-aarch64/builds/448
10.3 46857a860c90a643a8859e1bea81c727 |
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
|
Attachments
Issue Links
- relates to
-
MDEV-15352 AUTO_INCREMENT breaks after updating a column value to a negative number
- Closed
-
MDEV-16534 PPC64: Unexpected error with a negative value into auto-increment columns in HEAP, MyISAM, ARIA
- Closed