Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create interval partition not report error when partition numbers exceed limit number #55093

Closed
Defined2014 opened this issue Jul 31, 2024 · 2 comments · Fixed by #55097
Closed
Assignees
Labels
component/tablepartition This issue is related to Table Partition of TiDB. severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@Defined2014
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE employees (
    id int unsigned NOT NULL
) PARTITION BY RANGE (id) INTERVAL (1) FIRST PARTITION LESS THAN (1) LAST PARTITION LESS THAN (81920);

2. What did you expect to see? (Required)

report error

3. What did you see instead (Required)

no error, created a table with 8192 partitions.

4. What is your TiDB version? (Required)

@Defined2014 Defined2014 added type/bug The issue is confirmed as a bug. sig/sql-infra SIG: SQL Infra severity/moderate component/tablepartition This issue is related to Table Partition of TiDB. labels Jul 31, 2024
@Defined2014 Defined2014 self-assigned this Jul 31, 2024
@Defined2014
Copy link
Contributor Author

@mjonss Do you think it's a bug or not? Should we fix it?

@mjonss
Copy link
Contributor

mjonss commented Jul 31, 2024

@mjonss Do you think it's a bug or not? Should we fix it?

I consider it to be a bug, I propose to return an error instead of creating a table with one partition less than requested.

ti-chi-bot bot pushed a commit that referenced this issue Aug 1, 2024
hawkingrei pushed a commit to hawkingrei/tidb that referenced this issue Aug 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/tablepartition This issue is related to Table Partition of TiDB. severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
2 participants