[MDEV-22959] innodb.alter_varchar_change failed in buildbot with wrong result Created: 2020-06-19  Updated: 2022-02-21  Resolved: 2022-02-21

Status: Closed
Project: MariaDB Server
Component/s: Information Schema, Storage Engine - InnoDB, Tests
Affects Version/s: 10.5
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10, 10.6.0

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos6-x86/builds/1209

10.5 30d41c8102c36af7551b3ae77e48efbe

innodb.alter_varchar_change 'innodb'     w3 [ fail ]
        Test ended at 2020-06-15 20:48:04
 
CURRENT_TEST: innodb.alter_varchar_change
--- /usr/local/mariadb-10.5.4-linux-i686/mysql-test/suite/innodb/r/alter_varchar_change.result	2020-06-15 19:37:25.000000000 +0300
+++ /usr/local/mariadb-10.5.4-linux-i686/mysql-test/suite/innodb/r/alter_varchar_change.reject	2020-06-15 20:48:04.749806368 +0300
@@ -494,9 +494,11 @@
 create table t (a varchar(100)) engine=innodb;
 select name, pos, mtype, prtype, len from information_schema.innodb_sys_columns where name='a';
 name	pos	mtype	prtype	len
+a	0	6	1800	8
 a	0	1	524303	100
 alter table t modify a varchar(110), algorithm=inplace;
 select name, pos, mtype, prtype, len from information_schema.innodb_sys_columns where name='a';
 name	pos	mtype	prtype	len
+a	0	6	1800	8
 a	0	1	524303	110
 drop table t;
 
mysqltest: Result length mismatch



 Comments   
Comment by Marko Mäkelä [ 2022-02-21 ]

Here is the latest failure of this kind for a main branch that I could find:

10.6 a1542f8a57390bbad916ddfd335e1c75

innodb.alter_varchar_change 'innodb'     w3 [ fail ]
        Test ended at 2021-02-12 18:07:39
 
CURRENT_TEST: innodb.alter_varchar_change
--- /usr/share/mysql-test/suite/innodb/r/alter_varchar_change.result	2021-02-12 15:50:43.000000000 +0000
+++ /dev/shm/var/3/log/alter_varchar_change.reject	2021-02-12 18:07:39.736022969 +0000
@@ -494,9 +494,11 @@
 create table t (a varchar(100)) engine=innodb;
 select name, pos, mtype, prtype, len from information_schema.innodb_sys_columns where name='a';
 name	pos	mtype	prtype	len
+a	0	6	1800	8
 a	0	1	524303	100
 alter table t modify a varchar(110), algorithm=inplace;
 select name, pos, mtype, prtype, len from information_schema.innodb_sys_columns where name='a';
 name	pos	mtype	prtype	len
+a	0	6	1800	8
 a	0	1	524303	110
 drop table t;
 
mysqltest: Result length mismatch

The test was fixed on 10.2 on the same day.

Generated at Thu Feb 08 09:18:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.