innodb.instant_alter_null                w11 [ fail ]

        Test ended at 2025-03-19 06:52:09

CURRENT_TEST: innodb.instant_alter_null

mysqltest: At line 39: query 'select * from information_schema.innodb_sys_columns where table_id=@id' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:

< snip >

alter table t modify a int NULL, algorithm=instant;

ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE

drop table t;

create table t (

id int primary key,

a int NOT NULL default 0,

b int NOT NULL default 0,

c int NOT NULL default 0,

index idx (a,b,c)

) engine=innodb row_format=redundant;

insert into t (id, a) values (0, NULL);

ERROR 23000: Column 'a' cannot be null

insert into t (id, b) values (0, NULL);

ERROR 23000: Column 'b' cannot be null

insert into t (id, c) values (0, NULL);

ERROR 23000: Column 'c' cannot be null

insert into t values (1,1,1,1);

set @id = (select table_id from information_schema.innodb_sys_tables

where name = 'test/t');

select * from information_schema.innodb_sys_columns where table_id=@id;

More results from queries before failure can be found in /build/mysql-test/var/11/log/instant_alter_null.log

Server [mysqld.1 - pid: 184899, winpid: 184899, exit: 256] failed during test run

Server log from this test:

----------SERVER LOG START-----------

==184900==WARNING: MemorySanitizer: use-of-uninitialized-value

    #0 0x5580e9e718e7 in i_s_sys_columns_fill_table(THD*, TABLE_LIST*, Item*) /source/storage/innobase/handler/i_s.cc:5562:10

    #1 0x5580e6204e26 in get_schema_tables_result(JOIN*, enum_schema_table_state) /source/sql/sql_show.cc:9011:11

    #2 0x5580e5ee86e7 in JOIN::exec_inner() /source/sql/sql_select.cc:4621:7

    #3 0x5580e5ee36cb in JOIN::exec() /source/sql/sql_select.cc:4444:3

    #4 0x5580e5dc0614 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /source/sql/sql_select.cc:4921:9

    #5 0x5580e5dbcd1a in handle_select(THD*, LEX*, select_result*, unsigned long) /source/sql/sql_select.cc:449:10

    #6 0x5580e5bdb9f0 in execute_sqlcom_select(THD*, TABLE_LIST*) /source/sql/sql_parse.cc:6452:12

    #7 0x5580e5b96712 in mysql_execute_command(THD*) /source/sql/sql_parse.cc:4043:12

    #8 0x5580e5b5e026 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8252:18

    #9 0x5580e5b49bbb in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1891:7

    #10 0x5580e5b6288b in do_command(THD*) /source/sql/sql_parse.cc:1375:17

    #11 0x5580e68f1ac1 in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1386:11

    #12 0x5580e68f03cd in handle_one_connection /source/sql/sql_connect.cc:1298:5

    #13 0x5580e9332fc8 in pfs_spawn_thread /source/storage/perfschema/pfs.cc:2201:3

    #14 0x7ff9737d61c3  (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)

    #15 0x7ff97385685b  (/lib/x86_64-linux-gnu/libc.so.6+0x10985b) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)

  Uninitialized value was stored to memory at

    #0 0x5580e9e718e0 in i_s_sys_columns_fill_table(THD*, TABLE_LIST*, Item*) /source/storage/innobase/handler/i_s.cc:5564:18

    #1 0x5580e6204e26 in get_schema_tables_result(JOIN*, enum_schema_table_state) /source/sql/sql_show.cc:9011:11

    #2 0x5580e5ee86e7 in JOIN::exec_inner() /source/sql/sql_select.cc:4621:7

    #3 0x5580e5ee36cb in JOIN::exec() /source/sql/sql_select.cc:4444:3

    #4 0x5580e5dc0614 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /source/sql/sql_select.cc:4921:9

    #5 0x5580e5dbcd1a in handle_select(THD*, LEX*, select_result*, unsigned long) /source/sql/sql_select.cc:449:10

    #6 0x5580e5bdb9f0 in execute_sqlcom_select(THD*, TABLE_LIST*) /source/sql/sql_parse.cc:6452:12

    #7 0x5580e5b96712 in mysql_execute_command(THD*) /source/sql/sql_parse.cc:4043:12

    #8 0x5580e5b5e026 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8252:18

    #9 0x5580e5b49bbb in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1891:7

    #10 0x5580e5b6288b in do_command(THD*) /source/sql/sql_parse.cc:1375:17

    #11 0x5580e68f1ac1 in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1386:11

    #12 0x5580e68f03cd in handle_one_connection /source/sql/sql_connect.cc:1298:5

    #13 0x5580e9332fc8 in pfs_spawn_thread /source/storage/perfschema/pfs.cc:2201:3

    #14 0x7ff9737d61c3  (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)

  Uninitialized value was created by an allocation of 'nth_v_col' in the stack frame

    #0 0x5580e9e7150f in i_s_sys_columns_fill_table(THD*, TABLE_LIST*, Item*) /source/storage/innobase/handler/i_s.cc:5550:3