[MDEV-14243] CHECK PARTITION behavior is inconsistent between servers with disabled partitioning and without partitioning Created: 2017-11-01  Updated: 2020-12-01

Status: Open
Project: MariaDB Server
Component/s: Admin statements, Partitioning, Views
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.2

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

MariaDB [test]> create table t1 (i int);
Query OK, 0 rows affected (0.98 sec)
MariaDB [test]> create view v1 as select * from t1;
Query OK, 0 rows affected (0.07 sec)

Server compiled without partitioning

MariaDB [test]> SELECT plugin_status FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'partition';
Empty set (0.00 sec)
 
MariaDB [test]> alter table t1 check partition p1;
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MariaDB built with '--with-plugin-partition' to have it working
MariaDB [test]> alter table v1 check partition p1;
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MariaDB built with '--with-plugin-partition' to have it working

Server started without partitioning

MariaDB [test]> SELECT plugin_status FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'partition';
+---------------+
| plugin_status |
+---------------+
| DISABLED      |
+---------------+
1 row in set (0.00 sec)
 
MariaDB [test]> alter table t1 check partition p1;
ERROR 1505 (HY000): Partition management on a not partitioned table is not possible
MariaDB [test]> alter table v1 check partition p1;
+---------+-------+----------+-----------------------------+
| Table   | Op    | Msg_type | Msg_text                    |
+---------+-------+----------+-----------------------------+
| test.v1 | check | Error    | 'test.v1' is not BASE TABLE |
| test.v1 | check | status   | Operation failed            |
+---------+-------+----------+-----------------------------+
2 rows in set (0.00 sec)

It's somewhat strange that the second server pretends to attempt to perform CHECK PARTITION even though partitioning is disabled.


Generated at Thu Feb 08 08:12:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.