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

              Assignee:
              bar Alexander Barkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: