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

CONVERT TABLE TO PARTITION does not work for default list partition

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.7, 10.11, 11.0, 11.1, 11.2, 11.3
    • 10.11, 11.1, 11.2
    • Partitioning
    • None

    Description

      --source include/have_partition.inc
      		 
       
      		 
      create table t (a int) partition by list(a) (partition p0 values in (1,2));
      		 
      create table t1 (a int);
      		 
      insert into t1 values (10);
      		 
      alter table t convert table t1 to partition pn default;
      		 
      drop table if exists t1, t;

      10.7.8

      		 
      query 'alter table t convert table t1 to partition pn default' failed: ER_NO_PARTITION_FOR_GIVEN_VALUE (1526): Table has no partition for value 0

      Note that the value in the error message is also wrong, it is not related to the default-ness of the partition, see MDEV-33147.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-22165 CONVERT TABLE: move in partition from existing table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33147 Wrong value in the error message for ER_NO_PARTITION_FOR_GIVEN_VALUE

          • Major - Major loss of function.
          • Open

          Activity

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.