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

Table partitioned by LIST/RANGE COLUMNS(inet6) can be created, but not inserted into

    XMLWordPrintable

Details

    Description

      create or replace table t1 (a inet6) partition by list columns(a) (partition p1 values in ('::'));
      insert into t1 values ('::');
      

      10.5 fa843790

      > insert into t1 values ('::');
      ERROR 1654 (HY000): Partition column values of incorrect type
      

      I am not sure whether such partitioning is supposed to be supported. Since it works for BINARY and CHAR, I would expect yes; but if it doesn't work, it should be failing upon table creation, like with other data types:

      > create or replace table t1 (a decimal) partition by list columns(a) (partition p1 values in (0));
      ERROR 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              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.