[#MDEV-29781] Server crashes in ha_myisammrg::add_children_list upon CREATE OR REPLACE with MERGE

Note: Reproducible on bb-10.11-midenok which already has a fix for ~~MDEV-29698~~.

--source include/have_log_bin.inc

--source include/have_binlog_format_row.inc

CREATE TABLE t (a INT) ENGINE=MyISAM;

CREATE TEMPORARY TABLE tm (a INT) ENGINE=MERGE UNION=(t);

CREATE OR REPLACE TABLE tt LIKE tm;

# Cleanup

DROP TABLE tt, tm, t;

bb-10.11-midenok 8e82c973ee
#3 <signal handler called>
#4 0x000055f081ca72a0 in ha_myisammrg::add_children_list (this=0x61b00003dbb8) at /data/src/bb-10.11-midenok/storage/myisammrg/ha_myisammrg.cc:466
#5 0x000055f081cae845 in ha_myisammrg::extra (this=0x61b00003dbb8, operation=HA_EXTRA_ADD_CHILDREN_LIST) at /data/src/bb-10.11-midenok/storage/myisammrg/ha_myisammrg.cc:1335
#6 0x000055f0801dcf1e in mysql_create_like_table (thd=0x62c0000c0218, table=0x6290000e83c8, src_table=0x6290000e6af0, create_info=0x7f35fdaae7f0) at /data/src/bb-10.11-midenok/sql/sql_table.cc:5942
#7 0x000055f0802107a2 in Sql_cmd_create_table_like::execute (this=0x6290000e62f0, thd=0x62c0000c0218) at /data/src/bb-10.11-midenok/sql/sql_table.cc:12817
#8 0x000055f07ff1c392 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:5997
#9 0x000055f07ff29692 in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "CREATE OR REPLACE TABLE tt LIKE tm", length=34, parser_state=0x7f35fdaafa90) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:8023
#10 0x000055f07feffde4 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "CREATE OR REPLACE TABLE tt LIKE tm", packet_length=34, blocking=true) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:1894
#11 0x000055f07fefcbc8 in do_command (thd=0x62c0000c0218, blocking=true) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:1407
#12 0x000055f0803a53d8 in do_handle_one_connection (connect=0x608000002638, put_in_cache=true) at /data/src/bb-10.11-midenok/sql/sql_connect.cc:1416
#13 0x000055f0803a4d6e in handle_one_connection (arg=0x6080000025b8) at /data/src/bb-10.11-midenok/sql/sql_connect.cc:1318
#14 0x000055f080f7f6d8 in pfs_spawn_thread (arg=0x617000005498) at /data/src/bb-10.11-midenok/storage/perfschema/pfs.cc:2201
#15 0x00007f36073a9ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#16 0x00007f3606f98aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

[MDEV-29781] Server crashes in ha_myisammrg::add_children_list upon CREATE OR REPLACE with MERGE Created: 2022-10-12 Updated: 2023-01-27 Resolved: 2023-01-25
Status:	Closed
Project:	MariaDB Server
Component/s:	Data Definition - Create Table, Replication, Storage Engine - MyISAM
Affects Version/s:	10.11
Fix Version/s:	N/A

[MDEV-29781] Server crashes in ha_myisammrg::add_children_list upon CREATE OR REPLACE with MERGE Created: 2022-10-12 Updated: 2023-01-27 Resolved: 2023-01-25