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

          blocks

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-4912 Data type plugin API version 1

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

          Task - A task that needs to be done. MDEV-274 The data type for IPv6/IPv4 addresses in MariaDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20784 Testing for MDEV-274 (INET6, data type for IPv6/IPv4 addresses)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20856 Bad values in metadata views for partitions on VARBINARY

          • Major - Major loss of function.
          • Closed

          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.