catpineapple commented on code in PR #19597: URL: https://github.com/apache/doris/pull/19597#discussion_r1194528774
########## regression-test/suites/partition_p0/multi_partition/test_multi_partition.groovy: ########## @@ -321,4 +321,37 @@ suite("test_multi_partition") { assertEquals(result2.size(), 16) sql "drop table multi_par8" + + sql "drop table if exists multi_par9" + sql """ + CREATE TABLE IF NOT EXISTS multi_par9 ( + k1 tinyint NOT NULL, + k2 smallint NOT NULL, + k3 int NOT NULL, + k4 bigint NOT NULL, + k5 decimal(9, 3) NOT NULL, + k6 char(5) NOT NULL, + k10 date NOT NULL, + k11 datetime NOT NULL, + k12 datev2 NOT NULL, + k13 datetimev2 NOT NULL, + k14 datetimev2(3) NOT NULL, + k15 datetimev2(6) NOT NULL, + k7 varchar(20) NOT NULL, + k8 double max NOT NULL, + k9 float sum NOT NULL ) + AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k10,k11,k12,k13,k14,k15,k7) + PARTITION BY RANGE(k3) ( + FROM (1000) TO (10000) INTERVAL 200 Review Comment: build one partition : [1000,1001)。 ``` PartitionValue lowerPartitionValue = new PartitionValue(beginNum); beginNum += interval; Long currentEnd = Math.min(beginNum, endNum); PartitionValue upperPartitionValue = new PartitionValue(currentEnd); ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org