mariadbd: /10.5/sql/sql_partition_admin.cc:263: bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint): Assertion `table->s->db_create_options == part_table->s->db_create_options' failed.

200731 14:17:39 [ERROR] mysqld got signal 6 ;

Server version: 10.5.5-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7fd1a6b747bb]

stdlib/abort.c:81(__GI_abort)[0x7fd1a6b5f535]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fd1a6b5f40f]

??:0(__assert_fail)[0x7fd1a6b6d102]

sql/sql_partition_admin.cc:264(compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, unsigned int))[0x560ca6f9b632]

sql/sql_partition_admin.cc:630(Sql_cmd_alter_table_exchange_partition::exchange_partition(THD*, TABLE_LIST*, Alter_info*))[0x560ca6f97b0d]

sql/sql_partition_admin.cc:109(Sql_cmd_alter_table_exchange_partition::execute(THD*))[0x560ca6b8f64d]

sql/sql_parse.cc:5951(mysql_execute_command(THD*))[0x560ca6b9cc7c]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x560ca6b73b95]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560ca6b704ad]

sql/sql_parse.cc:1347(do_command(THD*))[0x560ca6f946c6]

sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x560ca6f94023]

sql/sql_connect.cc:1314(handle_one_connection)[0x560ca7c49886]

nptl/pthread_create.c:487(start_thread)[0x7fd1a762ffa3]

x86_64/clone.S:97(clone)[0x7fd1a6c364cf]

Query (0x62b0000382a8): ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2

SET SQL_MODE='';

CREATE TABLE t1 (a INT, b VARCHAR(55), PRIMARY KEY(a)) ENGINE=InnoDB PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN (100), PARTITION p2 VALUES LESS THAN (1000));

CREATE TABLE t2 (a INT, b VARCHAR(55), PRIMARY KEY(a)) CHECKSUM=1, ENGINE=InnoDB;

ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;

mysqld: /test/10.6_dbg/sql/sql_partition_admin.cc:262: bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint): Assertion `table->s->db_create_options == part_table->s->db_create_options' failed.

Core was generated by `/test/MD010121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[Current thread is 1 (Thread 0x149bd4097700 (LWP 1554364))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

#1  0x000056552d8b60d7 in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424

#2  0x000056552d04aab1 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x0000149bd626c859 in __GI_abort () at abort.c:79

#6  0x0000149bd626c729 in __assert_fail_base (fmt=0x149bd6402588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56552da4c420 "table->s->db_create_options == part_table->s->db_create_options", file=0x56552da4c158 "/test/10.6_dbg/sql/sql_partition_admin.cc", line=262, function=<optimized out>) at assert.c:92

#7  0x0000149bd627df36 in __GI___assert_fail (assertion=assertion@entry=0x56552da4c420 "table->s->db_create_options == part_table->s->db_create_options", file=file@entry=0x56552da4c158 "/test/10.6_dbg/sql/sql_partition_admin.cc", line=line@entry=262, function=function@entry=0x56552da4c460 "bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint)") at assert.c:101

#8  0x000056552cee2592 in compare_table_with_partition (part_id=0, part_elem=0x149b8403adc0, part_table=0x149b8401f428, table=0x149b840481f8, thd=0x149b84000db8) at /test/10.6_dbg/sql/sql_partition_admin.cc:262

#9  Sql_cmd_alter_table_exchange_partition::exchange_partition (this=this@entry=0x149b840135e0, thd=thd@entry=0x149b84000db8, table_list=<optimized out>, table_list@entry=0x149b840127d8, alter_info=alter_info@entry=0x149bd4095cc0) at /test/10.6_dbg/sql/sql_partition_admin.cc:630

#10 0x000056552cee2b75 in Sql_cmd_alter_table_exchange_partition::execute (this=0x149b840135e0, thd=0x149b84000db8) at /test/10.6_dbg/sql/sql_partition_admin.cc:109

#11 0x000056552cd8b4c6 in mysql_execute_command (thd=thd@entry=0x149b84000db8) at /test/10.6_dbg/sql/sql_parse.cc:5858

#12 0x000056552cd72072 in mysql_parse (thd=thd@entry=0x149b84000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x149bd40963d0) at /test/10.6_dbg/sql/sql_parse.cc:7881

#13 0x000056552cd801ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x149b84000db8, packet=packet@entry=0x149b84008d39 "ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2", packet_length=packet_length@entry=50) at /test/10.6_dbg/sql/sql_class.h:1293

#14 0x000056552cd8352d in do_command (thd=0x149b84000db8) at /test/10.6_dbg/sql/sql_parse.cc:1348

#15 0x000056552cedf7fc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56552f36ad98, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410

#16 0x000056552cedff03 in handle_one_connection (arg=arg@entry=0x56552f36ad98) at /test/10.6_dbg/sql/sql_connect.cc:1312

#17 0x000056552d39588f in pfs_spawn_thread (arg=0x56552f2a5e08) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201

#18 0x0000149bd677a609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#19 0x0000149bd6369293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

--source include/have_partition.inc                                                                                                                                      

--source include/have_innodb.inc

CREATE TABLE t1 (i INT NOT NULL, KEY (i)) ENGINE=InnoDB ROW_FORMAT=REDUNDANT PARTITION BY KEY(i) PARTITIONS 2;

CREATE TABLE t2 (i INT NOT NULL, KEY (i)) ENGINE=InnoDB;

--error ER_PARTITION_EXCHANGE_DIFFERENT_OPTION

ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;

# Cleanup

DROP TABLE t1, t2;

--source include/have_partition.inc

CREATE TABLE t1 (i INT NOT NULL, KEY (i)) ENGINE=Aria ROW_FORMAT=DYNAMIC PARTITION BY KEY(i) PARTITIONS 2;

CREATE TABLE t2 (i INT NOT NULL, KEY (i)) ENGINE=Aria;

--error ER_PARTITION_EXCHANGE_DIFFERENT_OPTION

ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;

# Cleanup

DROP TABLE t1, t2;

  /* Check compatible row_types and set create_info accordingly. */

  {

    enum row_type part_row_type= part_table->file->get_row_type();

    enum row_type table_row_type= table->file->get_row_type();

    if (part_row_type != table_row_type)

    {

      my_error(ER_PARTITION_EXCHANGE_DIFFERENT_OPTION, MYF(0),

               "ROW_FORMAT");

      DBUG_RETURN(true);

    }

    part_create_info.row_type= table->s->row_type;

  }

--source include/have_partition.inc

--source include/have_innodb.inc

CREATE TABLE t1 (a INT, PRIMARY KEY(a)) ENGINE=InnoDB PARTITION BY KEY(a) PARTITIONS 2;

CREATE TABLE t2 (a INT, PRIMARY KEY(a)) CHECKSUM=1, ENGINE=InnoDB;

ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;

# Cleanup

DROP TABLE t1, t2;

--source include/have_partition.inc

CREATE TABLE t1 (a INT, PRIMARY KEY(a)) PARTITION BY KEY(a) PARTITIONS 2;

CREATE TABLE t2 (a INT, PRIMARY KEY(a)) CHECKSUM=1;

--error ER_TABLES_DIFFERENT_METADATA

ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;

# Cleanup

DROP TABLE t1, t2;

--source include/have_partition.inc

CREATE TABLE t1 (a INT, PRIMARY KEY(a)) ENGINE=Aria PARTITION BY KEY(a) PARTITIONS 2;

CREATE TABLE t2 (a INT, PRIMARY KEY(a)) CHECKSUM=1 ENGINE=Aria;

--error ER_TABLES_DIFFERENT_METADATA

ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;

# Cleanup

DROP TABLE t1, t2;