CREATE TABLE t (a INT,b INT) ENGINE=InnoDB;

PREPARE s FROM 'WITH RECURSIVE cte AS (SELECT * FROM t WHERE a=1 UNION ALL SELECT a+1 FROM cte WHERE a<?) SELECT * FROM cte AS cte1,cte AS cte2';

SHUTDOWN;

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|THD::~THD|THD::~THD|do_handle_one_connection|handle_one_connection

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|THD::~THD|THD::~THD|one_thread_per_connection_end|do_handle_one_connection

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|Backtrace stopped: Cannot access memory at address

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|__isoc99_fscanf@plt

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|Diagnostics_area::set_error_status|THD::raise_condition|THD::raise_condition|my_message_sql

open_tables == __null|SIGABRT|Diagnostics_area::set_ok_status|my_ok|mysql_rm_table|mysql_execute_command

CREATE TABLE t (a INT);

ALTER TABLE t ADD COLUMN (b INT);

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

mysqld: /test/10.8_dbg/sql/sql_class.cc:1745: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed.

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

Program terminated with signal SIGABRT, Aborted.

#0  0x00001530c34f818b in ?? ()

[Current thread is 1 (LWP 2328496)]

(gdb) bt

#0  0x00001530c34f818b in ?? ()

#1  0x0000000000087007 in ?? ()

#2  0x00001530c354f850 in ?? ()

#3  0x00001530fbad8000 in ?? ()

#4  0x0000153074028020 in ?? ()

#5  0x0000153074028085 in ?? ()

#6  0x0000153074028020 in ?? ()

#7  0x0000153074028020 in ?? ()

#8  0x00001530740280be in ?? ()

#9  0x000015307402814c in ?? ()

#10 0x0000153074028020 in ?? ()

#11 0x000015307402814c in ?? ()

#12 0x0000000000000000 in ?? ()

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

Program terminated with signal SIGABRT, Aborted.

#0  0x000014ba1853918b in ?? ()

[Current thread is 1 (LWP 3208565)]

(gdb) bt

#0  0x000014ba1853918b in ?? ()

Backtrace stopped: Cannot access memory at address 0x14ba18076a00

query 'PREPARE s FROM 'WITH RECURSIVE cte AS (SELECT * FROM t WHERE a=1 UNION ALL SELECT a+1 FROM cte WHERE a<?) SELECT * FROM cte AS cte1,cte AS cte2'' failed: 1222: The used SELECT statements have a different number of columns

CREATE TABLE t (c1 INT, c2 DATE) TABLESPACE t STORAGE MEMORY;

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1,2 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

CREATE TABLE t (c1 INT, c2 DATE) TABLESPACE t STORAGE MEMORY;

--let $_server_id= `SELECT @@server_id`

--let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.$_server_id.expect

--exec echo "wait" > $_expect_file_name

--connect (c1,localhost,root,,)

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1,2 FROM d) SELECT * FROM d AS d1,d AS d2';

--send shutdown

--connection default

--source include/wait_until_disconnected.inc

--exec echo "restart" > $_expect_file_name

--enable_reconnect

--source include/wait_until_connected_again.inc

drop table t;

10.10.0-dbg>CREATE TABLE t (c1 INT, c2 DATE) TABLESPACE t STORAGE MEMORY;

Query OK, 0 rows affected (0.017 sec)

10.10.0-dbg>PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

ERROR 1222 (21000): The used SELECT statements have a different number of columns

10.10.0-dbg>SHUTDOWN;

Query OK, 0 rows affected (0.000 sec)

10.10.0-dbg>exit

Bye

qa-roel-2:/test/MD310522-mariadb-10.10.0-linux-x86_64-dbg$ ~/tt

----- Bug String  -----

status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory|SIGABRT|THD::~THD|THD::~THD|do_handle_one_connection|handle_one_connection

CREATE TABLE t (a INT,b INT) ROW_FORMAT=REDUNDANT ENGINE=InnoDB;

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

Warning: Memory not freed: 16448

CREATE TABLE t (a INT KEY,message CHAR,FULLTEXT (message)) COMMENT='';

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

2022-09-28 18:02:23 0 [Note] /test/MD190922-mariadb-10.11.0-linux-x86_64-opt/bin/mysqld: Shutdown complete

Warning: Memory not freed: 16496

CREATE TABLE t (c INT,d DATE) PARTITION BY RANGE (YEAR (d)) SUBPARTITION BY HASH (TO_DAYS (d)) (PARTITION p0 VALUES LESS THAN (1) (SUBPARTITION s0,SUBPARTITION s),PARTITION p VALUES LESS THAN MAXVALUE (SUBPARTITION s4,SUBPARTITION s5));

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

Warning: Memory not freed: 16808

CREATE TABLE t (a INT KEY,b INT,FOREIGN KEY(b) REFERENCES t (a)) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

SHUTDOWN;

CREATE TABLE t (c1 INT, c2 DATE) TABLESPACE t STORAGE MEMORY;

PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2';

main.test 'innodb'                       [ fail ]

        Test ended at 2023-09-25 13:54:05

CURRENT_TEST: main.test

mysqltest: At line 4: query 'PREPARE s FROM 'WITH RECURSIVE d AS (SELECT * FROM t UNION ALL SELECT 1 FROM d) SELECT * FROM d AS d1,d AS d2'' failed: 1222: The used SELECT statements have a different number of columns