Gabriel39 commented on code in PR #22690:
URL: https://github.com/apache/doris/pull/22690#discussion_r1287183755
##########
regression-test/suites/delete_p0/test_delete.groovy:
##########
@@ -250,4 +250,37 @@ suite("test_delete") {
sql 'select * from test1 order by x'
result([['a', 'a']])
}
+
+ // test delete where date type
+ sql 'ADMIN SET FRONTEND CONFIG ("enable_date_conversion" = "false");'
+
+ sql 'ADMIN SET FRONTEND CONFIG ("disable_datev1" = "false");'
+
+ sql """ DROP TABLE IF EXISTS cost """
+ sql """
+ CREATE TABLE `cost` (
+ `id` bigint(20) NULL,
+ `name` varchar(20) NULL,
+ `date` date NULL,
+ `cost` bigint(20) SUM NULL
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`id`, `name`, `date`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`id`, `name`) BUCKETS 8
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1"
+ );
+ """
+
+ sql "insert into cost values (1, 'abc', '2021-01-01', 100), (2, 'abc',
'2021-08-01', 100);"
+
+ qt_delete_date1 "select * from cost order by id"
+
+ sql "delete from cost where date = '2021-01-01';"
+
+ qt_delete_date2 "select * from cost order by id"
+
+ sql 'ADMIN SET FRONTEND CONFIG ("enable_date_conversion" = "true");'
Review Comment:
This will cause unpredicatable problems when running regression tests in
parallel.
--
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
