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

ALTER TABLE fails to rename a column in SYS_FIELDS

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
      CREATE TABLE t3 ( col1 INT, col_int INTEGER, col_text TEXT ) ENGINE = InnoDB;
      ALTER TABLE t3 ADD PRIMARY KEY ( col_text(9), col_int ) ;
      ALTER TABLE t3 ADD INDEX ( col_int, col1 ) ;
      ALTER TABLE t3 ADD COLUMN col_int_g_copy INTEGER GENERATED ALWAYS AS (col_int)  ;
      ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT ;
      # The last statement leads to crash.
      DROP TABLE t3;
       
      Version: '10.6.0-MariaDB-debug-log'  socket: '/home/mleich/Server_bin/10.6_debug/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      2021-02-02 12:58:25 4 [ERROR] InnoDB: No matching column for `col1` in index `col_int` of table `test`.`t3`
      210202 12:58:25 [ERROR] mysqld got signal 11 ;
      Query (0x7f4e54012dc0): ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT
       
      Connection ID (thread ID): 4
      Status: NOT_KILLED
       
      #0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x0000556d35791e13 in my_write_core (sig=11) at /home/mleich/Server/10.6/mysys/stacktrace.c:424
      #2  0x0000556d34e83b08 in handle_fatal_signal (sig=11) at /home/mleich/Server/10.6/sql/signal_handler.cc:330
      #3  <signal handler called>
      #4  0x0000556d3533ea7c in dict_stats_try_drop_table (thd=0x7f4e54000cf8, name=..., table_name=...) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:10096
      #5  0x0000556d3533ebf7 in innobase_reload_table (thd=0x7f4e54000cf8, table=0x0, table_name=..., ctx=...) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:10133
      #6  0x0000556d353417fc in ha_innobase::commit_inplace_alter_table (this=0x7f4e541c87d0, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, commit=true) at /home/mleich/Server/10.6/storage/innobase/handler/handler0alter.cc:11263
      #7  0x0000556d34e94a3e in handler::ha_commit_inplace_alter_table (this=0x7f4e541c87d0, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, commit=true) at /home/mleich/Server/10.6/sql/handler.cc:4855
      #8  0x0000556d34c27462 in mysql_inplace_alter_table (thd=0x7f4e54000cf8, table_list=0x7f4e54012ed0, table=0x7f4e5419c2a8, altered_table=0x7f4e7d62d960, ha_alter_info=0x7f4e7d62d8c0, target_mdl_request=0x7f4e7d62dd30, alter_ctx=0x7f4e7d62e880) at /home/mleich/Server/10.6/sql/sql_table.cc:8138
      #9  0x0000556d34c2ebd8 in mysql_alter_table (thd=0x7f4e54000cf8, new_db=0x7f4e54005768, new_name=0x7f4e54005b68, create_info=0x7f4e7d62f490, table_list=0x7f4e54012ed0, alter_info=0x7f4e7d62f3c0, order_num=0, order=0x0, ignore=false, if_exists=false) at /home/mleich/Server/10.6/sql/sql_table.cc:10683
      #10 0x0000556d34cd4d71 in Sql_cmd_alter_table::execute (this=0x7f4e540136c0, thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_alter.cc:539
      #11 0x0000556d34b3034d in mysql_execute_command (thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_parse.cc:5880
      #12 0x0000556d34b365e1 in mysql_parse (thd=0x7f4e54000cf8, rawbuf=0x7f4e54012dc0 "ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT", length=52, parser_state=0x7f4e7d630520) at /home/mleich/Server/10.6/sql/sql_parse.cc:7906
      #13 0x0000556d34b22af5 in dispatch_command (command=COM_QUERY, thd=0x7f4e54000cf8, packet=0x7f4e540087b9 "ALTER TABLE t3 CHANGE COLUMN IF EXISTS col1 otto INT ", packet_length=53) at /home/mleich/Server/10.6/sql/sql_parse.cc:1833
      #14 0x0000556d34b2143d in do_command (thd=0x7f4e54000cf8) at /home/mleich/Server/10.6/sql/sql_parse.cc:1365
      #15 0x0000556d34cca462 in do_handle_one_connection (connect=0x556d37f62df8, put_in_cache=true) at /home/mleich/Server/10.6/sql/sql_connect.cc:1410
      #16 0x0000556d34cca1d0 in handle_one_connection (arg=0x556d37f50f08) at /home/mleich/Server/10.6/sql/sql_connect.cc:1312
      #17 0x0000556d3520e213 in pfs_spawn_thread (arg=0x556d37ebab18) at /home/mleich/Server/10.6/storage/perfschema/pfs.cc:2201
      #18 0x00007f4e88f8d7fc in start_thread (arg=0x7f4e7d631700) at pthread_create.c:465
      #19 0x00007f4e881c3b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      10.6 8a495d7f90f64566d083d9ccd04cd95023a40931 2021-01-30T10:50:14+03:00
      origin/10.5 7c052cdf0bc53f8ee3387186993710bd9754b65d 2021-01-17T13:21:55+01:00
      origin/10.4 542d769ea1a22a7a6a87c9fe76ff911a162ade44 2021-01-28T07:39:34+02:00
      origin/10.3 df1eefb2ad138846269d40372678af805589700a 2021-01-07T17:53:04+01:00
      no replay on some 10.2 development tree mid of January
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            mleich Matthias Leich
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: