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

Partition by system_time can be converted into table but not back

    XMLWordPrintable

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

          Activity

            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.