Debian Codegraph @

mysql-test/suite/parts/inc/part_alter_values.inc

raw
1 --source include/have_symlink.inc
2
3 --echo #
4 --echo # MDEV-14641 Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine
5 --echo #
6
7 --eval CREATE TABLE t1 (i INT) ENGINE=$engine PARTITION BY LIST(i) (PARTITION p0 VALUES IN (1), PARTITION p1 VALUES IN (2));
8 ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
9 ALTER TABLE t1 DROP PARTITION p1;
10 SELECT * FROM t1;
11
12 # Cleanup
13 DROP TABLE t1;
14
15
16 --echo #
17 --echo # MDEV-13788 Server crash when issuing bad SQL partition syntax
18 --echo #
19
20 --eval CREATE TABLE t1 (id int, d date) ENGINE=$engine PARTITION BY RANGE COLUMNS(d) (PARTITION p1 VALUES LESS THAN (MAXVALUE))
21 SHOW CREATE TABLE t1;
22 --error ER_PARTITION_REQUIRES_VALUES_ERROR
23 ALTER TABLE t1 REORGANIZE PARTITION p1 INTO
24 (
25 PARTITION p2, /* Notice no values */
26 PARTITION p3 VALUES LESS THAN (MAXVALUE)
27 );
28 DROP TABLE t1;
29
30
31 --eval CREATE TABLE t1 (id int, d date) ENGINE=$engine PARTITION BY LIST (id) (PARTITION p1 VALUES IN (1,2,3))
32 SHOW CREATE TABLE t1;
33 --error ER_PARTITION_REQUIRES_VALUES_ERROR
34 ALTER TABLE t1 REORGANIZE PARTITION p1 INTO
35 (
36 PARTITION p2, /* Notice no values */
37 PARTITION p3 VALUES IN (4,5,6)
38 );
39 DROP TABLE t1;
40
41 --echo #
42 --echo # MDEV-15456 Server crashes upon adding or dropping a partition in ALTER under LOCK TABLE after ER_SAME_NAME_PARTITION
43 --echo #
44 --eval create table t1 (i int) engine=$engine partition by range(i) (partition p0 values less than (10))
45 lock table t1 write;
46 --error ER_SAME_NAME_PARTITION
47 alter table t1 add partition (partition p0 values less than (20));
48 alter table t1 add partition (partition p1 values less than (20)) /* comment */;
49 drop table t1;
50
51 --echo #
52 --echo # MDEV-27065 Partitioning tables with custom data directories moves data back to default directory
53 --echo #
54
55 --mkdir $MYSQLTEST_VARDIR/tmp/mdev_27065
56
57 --disable_query_log
58 --eval CREATE TABLE t1 (id INT) ENGINE=$engine DATA DIRECTORY='$MYSQLTEST_VARDIR/tmp/mdev_27065'
59 --enable_query_log
60 ALTER TABLE t1 PARTITION BY RANGE(id)(
61 PARTITION p0 VALUES LESS THAN (1000),
62 PARTITION p1 VALUES LESS THAN MAXVALUE
63 );
64 DROP TABLE t1;
65
66 # InnoDB doesn't support INDEX DIRECTORY.
67 if (`SELECT IF('$engine' != 'InnoDB', 1, 0)`)
68 {
69 --disable_query_log
70 --eval CREATE TABLE t2 (id INT) ENGINE=$engine INDEX DIRECTORY='$MYSQLTEST_VARDIR/tmp/mdev_27065'
71 --enable_query_log
72 ALTER TABLE t2 PARTITION BY RANGE(id)(
73 PARTITION p0 VALUES LESS THAN (1000),
74 PARTITION p1 VALUES LESS THAN MAXVALUE
75 );
76 DROP TABLE t2;
77 }
78
79 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp/mdev_27065 *
80 --rmdir $MYSQLTEST_VARDIR/tmp/mdev_27065
81
82 --echo #
83 --echo # MDEV-26127 Assertion `err != DB_DUPLICATE_KEY' failed or InnoDB: Failing assertion: id != 0 on ALTER ... REBUILD PARTITION
84 --echo #
85 --eval CREATE TABLE t1 (c INT) ENGINE=$engine PARTITION BY KEY(c) PARTITIONS 4;
86 LOCK TABLES t1 WRITE, t1 AS a READ;
87 ALTER TABLE t1 REBUILD PARTITION p0;
88 DROP TABLE t1;