failed to create interval partition at minute interval

[dbsid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> CREATE TABLE t (     a int NOT NULL,     b varchar(20) NOT NULL,     c datetime NOT NULL ) PARTITION BY RANGE COLUMNS (c) INTERVAL (1 MINUTE) FIRST PARTITION LESS THAN ('2024-01-01') LAST PARTITION LESS THAN ('2024-02-01');
ERROR 8200 (HY000): Unsupported INTERVAL partitioning, only supports YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE and SECOND as time unit
mysql> CREATE TABLE t (     a int NOT NULL,     b varchar(20) NOT NULL,     c datetime NOT NULL ) PARTITION BY RANGE COLUMNS (c) INTERVAL (1 HOUR) FIRST PARTITION LESS THAN ('2024-01-01') LAST PARTITION LESS THAN ('2024-02-01');
Query OK, 0 rows affected (0.20 sec)

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

INTERVAL (1 MINUTE) does not work.
INTERVAL (1 Hour) works

3. What did you see instead (Required)

INTERVAL (1 MINUTE) works.

4. What is your TiDB version? (Required)

v8.3.0

[mjonss]

Looks like a typo bug :)
Fixed by:

diff --git a/pkg/ddl/partition.go b/pkg/ddl/partition.go
index 43bcd1a785..bb38a26755 100644
--- a/pkg/ddl/partition.go
+++ b/pkg/ddl/partition.go
@@ -1037,7 +1037,7 @@ func generatePartitionDefinitionsFromInterval(ctx expression.BuildContext, partO
                return dbterror.ErrGeneralUnsupportedDDL.GenWithStackByArgs("INTERVAL partitioning, currently requires FIRST and LAST partitions to be defined")
        }
        switch partOptions.Interval.IntervalExpr.TimeUnit {
-       case ast.TimeUnitInvalid, ast.TimeUnitYear, ast.TimeUnitQuarter, ast.TimeUnitMonth, ast.TimeUnitWeek, ast.TimeUnitDay, ast.TimeUnitHour, ast.TimeUnitDayMinute, ast.TimeUnitSecond:
+       case ast.TimeUnitInvalid, ast.TimeUnitYear, ast.TimeUnitQuarter, ast.TimeUnitMonth, ast.TimeUnitWeek, ast.TimeUnitDay, ast.TimeUnitHour, ast.TimeUnitMinute, ast.TimeUnitSecond:
        default:
                return dbterror.ErrGeneralUnsupportedDDL.GenWithStackByArgs("INTERVAL partitioning, only supports YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE and SECOND as time unit")
        }