[MDEV-18555] Server crashes in mysql_alter_table with ALTER ONLINE and sql_mode='NO_ZERO_DATE' Created: 2019-02-12  Updated: 2019-02-12  Resolved: 2019-02-12

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alice Sherepa
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-18042 Server crashes in mysql_alter_table u... Closed

 Description   

Reproducible on 10.2-10.4 with MyIsam and Aria, not with Innodb

set sql_mode='NO_ZERO_DATE';
create table t1 (i int) engine=myisam;
 
alter online table t1 add (d1 date not null);

10.2 ca325a46d230438ab06b8fe445

==25279==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x55b7c917f8c2 bp 0x7f9dc1110ca0 sp 0x7f9dc110f330 T27)
    #0 0x55b7c917f8c1 in mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool) /10.2/sql/sql_table.cc:9831
    #1 0x55b7c929eb5a in Sql_cmd_alter_table::execute(THD*) /10.2/sql/sql_alter.cc:329
    #2 0x55b7c8f85bf1 in mysql_execute_command(THD*) /10.2/sql/sql_parse.cc:6231
    #3 0x55b7c8f90430 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.2/sql/sql_parse.cc:8018
    #4 0x55b7c8f6b91c in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.2/sql/sql_parse.cc:1829
    #5 0x55b7c8f68a4b in do_command(THD*) /10.2/sql/sql_parse.cc:1379
    #6 0x55b7c9290f36 in do_handle_one_connection(CONNECT*) /10.2/sql/sql_connect.cc:1336
    #7 0x55b7c929093e in handle_one_connection /10.2/sql/sql_connect.cc:1242
    #8 0x55b7ca44004b in pfs_spawn_thread /10.2/storage/perfschema/pfs.cc:1862
    #9 0x7f9dd86e96b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
    #10 0x7f9dd7b7e41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)


Generated at Thu Feb 08 08:45:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.