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

Wrong error message upon selecting from a system_time partition

    XMLWordPrintable

Details

    Description

      create or replace table t1 (i int) with system versioning partition by system_time limit 10 (partition p0 history, partition pn current);
      select * from t1 partition (p0) for system_time all;
      

      ERROR 4129 (HY000): Table `t1 PARTITION (p0)` is not system-versioned
      

      As it turns out, the idea is that SELECT .. FOR system_time should work for normal partitions, but not for system_time partitions. It's impossible to understand that from the error message.

      Attachments

        Activity

          People

            midenok Aleksey Midenkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.