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

Auto-create: Bad error message upon failure to create partitions due to ER_TOO_MANY_PARTITIONS_ERROR

    XMLWordPrintable

Details

    Description

      The test case is taken from the MTR test, so there is no need to add it anywhere:

      set timestamp= unix_timestamp('2000-01-01 00:00:00');
      create or replace table t1 (x int) with system versioning partition by system_time interval 1 hour auto;
      set timestamp= unix_timestamp('2001-01-01 00:01:00');
      update t1 set x= x + 1;
      

      The UPDATE results in

      bb-10.6-midenok-MDEV-17554 b96b96f9f3e

      MariaDB [test]>  update t1 set x= x + 1;
      ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined
      

      While it is indeed what happens underneath, the error message is really unsuitable and confusing in this situation: UPDATE doesn't define any partitions at all, and in this case even the table definition doesn't "define too many partitions".

      Attachments

        Issue Links

          Activity

            People

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