This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 7b5cc2ab31e branch-3.1: [fix](nereids)'VALUES IN' keyword should be
optional in list partition definition #52986 (#53253)
7b5cc2ab31e is described below
commit 7b5cc2ab31e2fc1c8116f461c9190cecca54f8a7
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jul 15 15:35:31 2025 +0800
branch-3.1: [fix](nereids)'VALUES IN' keyword should be optional in list
partition definition #52986 (#53253)
Cherry-picked from #52986
Co-authored-by: starocean999 <[email protected]>
---
fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4 | 2 +-
.../suites/partition_p0/list_partition/test_list_partition.groovy | 6 +++---
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
index 629269d875e..be449f811dc 100644
--- a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
+++ b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
@@ -1426,7 +1426,7 @@ stepPartitionDef
;
inPartitionDef
- : PARTITION (IF NOT EXISTS)? partitionName=identifier (VALUES IN
((LEFT_PAREN partitionValueLists+=partitionValueList
+ : PARTITION (IF NOT EXISTS)? partitionName=identifier ((VALUES IN)?
((LEFT_PAREN partitionValueLists+=partitionValueList
(COMMA partitionValueLists+=partitionValueList)* RIGHT_PAREN) |
constants=partitionValueList))?
;
diff --git
a/regression-test/suites/partition_p0/list_partition/test_list_partition.groovy
b/regression-test/suites/partition_p0/list_partition/test_list_partition.groovy
index a12879393e6..4ce19d7bb28 100644
---
a/regression-test/suites/partition_p0/list_partition/test_list_partition.groovy
+++
b/regression-test/suites/partition_p0/list_partition/test_list_partition.groovy
@@ -38,7 +38,7 @@ suite("test_list_partition", "p0") {
AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k10,k11,k12,k13,k14,k15,k7)
PARTITION BY LIST(k1) (
PARTITION p1 VALUES IN ("1","2","3","4"),
- PARTITION p2 VALUES IN
("5","6","7","8","9","10","11","12","13","14"),
+ PARTITION p2 ("5","6","7","8","9","10","11","12","13","14"),
PARTITION p3 VALUES IN ("15") )
DISTRIBUTED BY HASH(k1) BUCKETS 5 properties("replication_num" = "1")
"""
@@ -67,9 +67,9 @@ suite("test_list_partition", "p0") {
AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k10,k11,k7)
PARTITION BY LIST(k1) (
PARTITION p1 VALUES IN
("-128","-127","-126","-125","-124","-123","-122","-121","-120","-119","-118","-117","-116","-115","-114","-113","-112","-111","-110","-109","-108","-107","-106","-105","-104","-103","-102","-101","-100","-99","-98","-97","-96","-95","-94","-93","-92","-91","-90","-89","-88","-87","-86","-85","-84","-83","-82","-81","-80","-79","-78","-77","-76","-75","-74","-73","-72","-71","-70","-69","-68","-67","-66","-65"),
- PARTITION p2 VALUES IN
("-64","-63","-62","-61","-60","-59","-58","-57","-56","-55","-54","-53","-52","-51","-50","-49","-48","-47","-46","-45","-44","-43","-42","-41","-40","-39","-38","-37","-36","-35","-34","-33","-32","-31","-30","-29","-28","-27","-26","-25","-24","-23","-22","-21","-20","-19","-18","-17","-16","-15","-14","-13","-12","-11","-10","-9","-8","-7","-6","-5","-4","-3","-2","-1"),
+ PARTITION p2
("-64","-63","-62","-61","-60","-59","-58","-57","-56","-55","-54","-53","-52","-51","-50","-49","-48","-47","-46","-45","-44","-43","-42","-41","-40","-39","-38","-37","-36","-35","-34","-33","-32","-31","-30","-29","-28","-27","-26","-25","-24","-23","-22","-21","-20","-19","-18","-17","-16","-15","-14","-13","-12","-11","-10","-9","-8","-7","-6","-5","-4","-3","-2","-1"),
PARTITION p3 VALUES IN
("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63"),
- PARTITION p4 VALUES IN
("64","65","66","67","68","69","70","71","72","73","74","75","76","77","78","79","80","81","82","83","84","85","86","87","88","89","90","91","92","93","94","95","96","97","98","99","100","101","102","103","104","105","106","107","108","109","110","111","112","113","114","115","116","117","118","119","120","121","122","123","124","125","126","127")
+ PARTITION p4
("64","65","66","67","68","69","70","71","72","73","74","75","76","77","78","79","80","81","82","83","84","85","86","87","88","89","90","91","92","93","94","95","96","97","98","99","100","101","102","103","104","105","106","107","108","109","110","111","112","113","114","115","116","117","118","119","120","121","122","123","124","125","126","127")
)
DISTRIBUTED BY HASH(k1) BUCKETS 5
properties("replication_num" = "1")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
