Skip to content

Create Range columns type partition error #7607

Closed
@ciscoxll

Description

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
create table t29 (
    a decimal
)  partition by range columns (a)(
    partition p0 values less than (0)
);
  1. What did you expect to see?

Meet no error.

  1. What did you see instead?
ERROR HY000: Field 'a' is of a not allowed type for this type of partitioning

The range partition comes in two varieties:

  • a. partition by range(expr) support
  • b. partition by range columns(column_list) not support

Range columns partition only implements the parser, so it will not be checked. So the DDL should run successfully.

  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

master branch 129f499

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions