|
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
|
|