[Bug]: HASH PARTITIONING can use VALUES LESS THAN AND VALUES IN in partition definition #18874
Open
1 task done
Labels
kind/bug
Something isn't working
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
Milestone
Is there an existing issue for the same bug?
Branch Name
main
Commit ID
afd7c53
Other Environment Information
Actual Behavior
MO:
mysql> CREATE TABLE t1 (
-> a int not null,
-> b int not null,
-> c int not null,
-> primary key(a,b))
-> partition by hash (a)
-> partitions 2
-> (partition x1 values less than (4),
-> partition x2 values less than (5));
Query OK, 0 rows affected (0.08 sec)
mysql> CREATE TABLE t1 (
-> a int not null,
-> b int not null,
-> c int not null,
-> primary key(a,b))
-> partition by hash (a)
-> partitions 2
-> (partition x1 values in (4),
-> partition x2 values in (5));
Query OK, 0 rows affected (0.06 sec)
MYSQL:
mysql> CREATE TABLE t1 (
-> a int not null,
-> b int not null,
-> c int not null,
-> primary key(a,b))
-> partition by hash (a)
-> partitions 2
-> (partition x1 values less than (4),
-> partition x2 values less than (5));
ERROR 1480 (HY000): Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition
mysql> CREATE TABLE t1 (
-> a int not null,
-> b int not null,
-> c int not null,
-> primary key(a,b))
-> partition by hash (a)
-> partitions 2
-> (partition x1 values in (4),
-> partition x2 values in (5));
ERROR 1480 (HY000): Only LIST PARTITIONING can use VALUES IN in partition definition
Expected Behavior
No response
Steps to Reproduce
Additional information
No response
The text was updated successfully, but these errors were encountered: