Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4
-
None
Description
https://buildbot.mariadb.org/#/builders/862/builds/15798/steps/17/logs/stdio
gcol.innodb_virtual_basic w8 [ fail ]
|
Test ended at 2026-07-17 19:53:14
|
CURRENT_TEST: gcol.innodb_virtual_basic
|
mysqltest: At line 519: The result of the 1st execution does not match with
|
the result of the 2nd execution of ps-protocol:
|
1st:
|
a c
|
NULL NULL
|
11 14
|
18 19
|
28 29
|
2nd:
|
a c
|
11 14
|
18 19
|
28 29
|
NULL NULL
|
The result from queries just before the failure was:
|
< snip >
|
`e` INT(11) GENERATED ALWAYS AS (10) VIRTUAL,
|
`h` INT(11) NOT NULL,
|
PRIMARY KEY (`h`),
|
KEY `m3` (`m3`),
|
KEY `c` (`c`(100)),
|
KEY `e` (`e`,`d`(20))
|
) ENGINE=InnoDB;
|
INSERT INTO t VALUES (1, 2, DEFAULT, 3, "aaa", DEFAULT, REPEAT('g', 10000), REPEAT('x', 2800), DEFAULT, DEFAULT, DEFAULT, 1);
|
INSERT INTO t VALUES (11, 21, DEFAULT, 31, "bbb", DEFAULT, REPEAT('a', 9000), REPEAT('b', 2000), DEFAULT, DEFAULT, DEFAULT, 2);
|
INSERT INTO t VALUES (21, 31, DEFAULT, 41, "zzz", DEFAULT, REPEAT('m', 8000), REPEAT('n', 3000), DEFAULT, DEFAULT, DEFAULT, 3);
|
ALTER TABLE t DROP COLUMN c;
|
DELETE FROM t;
|
DROP TABLE t;
|
CREATE TABLE t (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10));
|
INSERT INTO t VALUES (11, 3, DEFAULT, 'mm');
|
INSERT INTO t VALUES (18, 1, DEFAULT, 'mm');
|
INSERT INTO t VALUES (28, 1, DEFAULT, 'mm');
|
INSERT INTO t VALUES (null, null, DEFAULT, 'mm');
|
CREATE INDEX idx ON t(a, c);
|
SELECT a, c FROM t;
|
More results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/8/log/innodb_virtual_basic.log
|
- saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/8/log/gcol.innodb_virtual_basic/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/gcol.innodb_virtual_basic/'
|
Retrying test gcol.innodb_virtual_basic, attempt(2/3)...
|