Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18555

Server crashes in mysql_alter_table with ALTER ONLINE and sql_mode='NO_ZERO_DATE'

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.2, 10.3, 10.4
    • N/A
    • N/A
    • None

    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)
      

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.