Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14243

CHECK PARTITION behavior is inconsistent between servers with disabled partitioning and without partitioning

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.