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

Partition by system_time can be converted into table but not back

Details

    Description

      CONVERT PARTITION / CONVERT TABLE is asymmetrical for system versioning. A partition can be converted into a table, but it doesn't work the other way round:

      10.7 120a4caf

      		 
      create or replace table t (a int) with system versioning partition by system_time limit 10 partitions 3;
      		 
      alter table t convert partition p0 to table tp;
      		 
      alter table t convert table tp to partition p0;
      		 
      bug.t2                                   [ fail ]
      		 
              Test ended at 2022-10-21 00:36:09
      		 
       
      		 
      CURRENT_TEST: bug.t2
      		 
      mysqltest: At line 5: query 'alter table t convert table tp to partition p0' failed: ER_PARTITION_WRONG_TYPE (4113): Wrong partitioning type, expected type: `SYSTEM_TIME`

      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

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		10d 9h 20m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            		6h 27m 1
            Nikita Malyavin made transition -
            In Review Stalled
            		21m 20s 1
            Aleksey Midenkov made transition -
            Stalled Closed
            		6h 1

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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