# including crashing tests.

--source include/have_debug.inc

--source include/have_partition.inc

# Don't test this under valgrind, memory leaks will occur

--source include/not_valgrind.inc

# Crash tests don't work with embedded

--source include/not_embedded.inc

# Make sure system tables are not open, as the test will kill the server

# and it will cause corruption errors in the log

FLUSH TABLES;

--echo #

--echo # MDEV-22166 CONVERT PARTITION: move out partition into a table

--echo #

let $create_statement= create or replace table t1 (x int primary key)

  partition by range(x) (

    partition p1 values less than (10),

    partition p2 values less than (20),

    partition p3 values less than (30),

    partition p4 values less than (40),

    partition p5 values less than (50),

    partition pn values less than maxvalue);

let $insert_statement= insert into t1 values (2), (12), (22), (32), (42), (52);

let $fail_statement= alter table t1 convert partition p2 to table tp2;

set @save_dbug=@@debug_dbug;

set session debug_dbug="+d,fail_convert_partition_5";

--source suite/parts/inc/partition_fail.inc

set session debug_dbug=@save_dbug;

set session debug_dbug="+d,fail_convert_partition_11";

--echo # Already finished DDL logging, so tp2 now exists:

--source suite/parts/inc/partition_fail.inc

set session debug_dbug=@save_dbug;

show create table tp2;

select * from tp2;

drop table tp2;