summaryrefslogtreecommitdiff
path: root/mysql-test/main/invisible_partition.test
blob: dd3b3eeaaaecfdb2a8516e7c25b4137e899d2398 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
--source include/have_partition.inc
--source include/have_binlog_format_row.inc
--source include/have_debug.inc

CREATE TABLE t1 (a INT NOT NULL, KEY (a)) ENGINE=MEMORY PARTITION BY KEY(a) PARTITIONS 4;
INSERT INTO t1 VALUES (1),(2);
SET debug_dbug="+d,test_pseudo_invisible";
--error ER_INTERNAL_ERROR
ALTER TABLE t1 REBUILD PARTITION p2;
SET debug_dbug='';
ALTER TABLE t1 REPAIR PARTITION p1,p2,p3;

# Cleanup
Drop table t1;
#Mdev-14850
CREATE TABLE t1 (i INT) PARTITION BY HASH (i) PARTITIONS 3;
SET debug_dbug= "+d,test_pseudo_invisible";
--error ER_INTERNAL_ERROR
ALTER TABLE t1 COALESCE PARTITION 1;
SET debug_dbug= "";
SELECT * FROM t1;

# Cleanup
DROP TABLE t1;