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

Misleading ER_VERS_ENGINE_UNSUPPORTED upon attempt to partition the table

    XMLWordPrintable

Details

    Description

      Note: I think it's been discussed earlier, filing it so that we don't forget it should be looked at.

      create or replace table t (i int) engine=InnoDB with system versioning partition by system_time interval 1 day (partition p1 versioning, partition plast as of current_timestamp);

      bb-10.3-temporal 2ae2876a6ce4b1

      		 
      ERROR 4109 (HY000): Engine does not support System Versioning for `t`

      It's not a great error message, if possible, it would be better to change it.
      I don't know if it can be done easily though, because we have similar legacy problems, like

      create table t1 (i INT, p POINT) ENGINE=InnoDB PARTITION BY HASH(i) PARTITIONS 2;


      ERROR 1178 (42000): The storage engine for the table doesn't support GEOMETRY

      etc.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14678 Misleading ER_VERS_ENGINE_UNSUPPORTED upon wrong use of AS OF TRANSACTION

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          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.