Fixed crash in failing instant alter table with partitioned table

MDEV-22649 SIGSEGV in ha_partition::create_partitioning_metadata on ALTER
MDEV-22804 SIGSEGV in ha_partition::create_partitioning_metadata

1 files changed, 23 insertions, 0 deletions

diff --git a/mysql-test/suite/parts/r/alter_table.result b/mysql-test/suite/parts/r/alter_table.result
new file mode 100644
index 00000000000..fc508663204
--- /dev/null
+++ b/mysql-test/suite/parts/r/alter_table.result
@@ -0,0 +1,23 @@
+set @save_alter_algorithm= @@session.alter_algorithm;
+SET SESSION alter_algorithm=4;
+CREATE TABLE t1(a INT) engine=myisam PARTITION BY RANGE(a) SUBPARTITION BY KEY(a) (PARTITION p0 VALUES LESS THAN (10) (SUBPARTITION s0,SUBPARTITION s1), PARTITION p1 VALUES LESS THAN (20) (SUBPARTITION s2,SUBPARTITION s3));
+show create table t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` int(11) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
+ PARTITION BY RANGE (`a`)
+SUBPARTITION BY KEY (`a`)
+(PARTITION `p0` VALUES LESS THAN (10)
+ (SUBPARTITION `s0` ENGINE = MyISAM,
+  SUBPARTITION `s1` ENGINE = MyISAM),
+ PARTITION `p1` VALUES LESS THAN (20)
+ (SUBPARTITION `s2` ENGINE = MyISAM,
+  SUBPARTITION `s3` ENGINE = MyISAM))
+ALTER TABLE t1 ADD COLUMN c INT;
+ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
+DROP table if exists t1;
+set @@session.alter_algorithm= @save_alter_algorithm;
+CREATE TABLE t1 (a INT) PARTITION BY RANGE(a) SUBPARTITION BY HASH(a) (PARTITION p VALUES LESS THAN (5) (SUBPARTITION sp, SUBPARTITION sp1), PARTITION p1 VALUES LESS THAN MAXVALUE (SUBPARTITION sp2, SUBPARTITION sp3));
+ALTER TABLE t1 DROP PARTITION p;
+DROP TABLE if exists t1;