You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by st...@apache.org on 2024/09/13 12:24:52 UTC
(doris) branch master updated: [test](planner) fix generated column delete cases (#40706)
This is an automated email from the ASF dual-hosted git repository.
starocean999 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 5479e62f984 [test](planner) fix generated column delete cases (#40706)
5479e62f984 is described below
commit 5479e62f98476190873bd074a17df672988b6809
Author: feiniaofeiafei <53...@users.noreply.github.com>
AuthorDate: Fri Sep 13 20:24:44 2024 +0800
[test](planner) fix generated column delete cases (#40706)
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
---
.../test_delete_generated_column.out | 24 ----------------------
.../test_delete_generated_column.groovy | 16 +++++++--------
2 files changed, 8 insertions(+), 32 deletions(-)
diff --git a/regression-test/data/ddl_p0/test_create_table_generated_column/test_delete_generated_column.out b/regression-test/data/ddl_p0/test_create_table_generated_column/test_delete_generated_column.out
index 1f14f41375b..2441607cf64 100644
--- a/regression-test/data/ddl_p0/test_create_table_generated_column/test_delete_generated_column.out
+++ b/regression-test/data/ddl_p0/test_create_table_generated_column/test_delete_generated_column.out
@@ -1,52 +1,28 @@
-- This file is automatically generated. You should know what you did if you want to edit this
--- !delete_where_gen_col --
-0
-
-- !delete_where_gen_col_select --
2 22 24
10 2 12
--- !delete_where_gen_col_partition_has_no_satisfied_row --
-0
-
-- !delete_where_gen_col_partition_has_no_satisfied_row_select --
2 22 24
10 2 12
--- !delete_where_gen_col_and_other_col --
-0
-
-- !delete_where_gen_col_and_other_col_select --
2 22 24
--- !delete_where_gen_col_unique --
-1
-
-- !delete_where_gen_col_select_unique --
2 22 24
10 2 12
--- !delete_where_gen_col_partition_has_no_satisfied_row_unique --
-0
-
-- !delete_where_gen_col_partition_has_no_satisfied_row_select_unique --
2 22 24
10 2 12
--- !delete_where_gen_col_and_other_col_unique --
-1
-
-- !delete_where_gen_col_and_other_col_select_unique --
2 22 24
--- !delete_query --
-1
-
-- !delete_query_select --
--- !delete_query_cte --
-1
-
-- !delete_query_cte_select --
1 2 3
10 2 12
diff --git a/regression-test/suites/ddl_p0/test_create_table_generated_column/test_delete_generated_column.groovy b/regression-test/suites/ddl_p0/test_create_table_generated_column/test_delete_generated_column.groovy
index 09b4b3dfaa2..8cbe723d929 100644
--- a/regression-test/suites/ddl_p0/test_create_table_generated_column/test_delete_generated_column.groovy
+++ b/regression-test/suites/ddl_p0/test_create_table_generated_column/test_delete_generated_column.groovy
@@ -45,25 +45,25 @@ suite("test_generated_column_delete") {
insert into test_par_gen_col_unique values(1,2,default),(10,2,default),(2,22,default),(10,2,default);
"""
- qt_delete_where_gen_col "delete from test_par_gen_col partition p1 where c=3;"
+ sql "delete from test_par_gen_col partition p1 where c=3;"
qt_delete_where_gen_col_select "select * from test_par_gen_col order by a,b,c;"
- qt_delete_where_gen_col_partition_has_no_satisfied_row "delete from test_par_gen_col partition p1 where c=12;"
+ sql "delete from test_par_gen_col partition p1 where c=12;"
qt_delete_where_gen_col_partition_has_no_satisfied_row_select "select * from test_par_gen_col order by a,b,c;;"
- qt_delete_where_gen_col_and_other_col "delete from test_par_gen_col partition p2 where c=12 and a=10;"
+ sql "delete from test_par_gen_col partition p2 where c=12 and a=10;"
qt_delete_where_gen_col_and_other_col_select "select * from test_par_gen_col order by a,b,c;;"
- qt_delete_where_gen_col_unique "delete from test_par_gen_col_unique partition p1 where c=3;"
+ sql "delete from test_par_gen_col_unique partition p1 where c=3;"
qt_delete_where_gen_col_select_unique "select * from test_par_gen_col_unique order by a,b,c;;"
- qt_delete_where_gen_col_partition_has_no_satisfied_row_unique "delete from test_par_gen_col_unique partition p1 where c=12;"
+ sql "delete from test_par_gen_col_unique partition p1 where c=12;"
qt_delete_where_gen_col_partition_has_no_satisfied_row_select_unique "select * from test_par_gen_col_unique order by a,b,c;;"
- qt_delete_where_gen_col_and_other_col_unique "delete from test_par_gen_col_unique partition p2 where c=12 and a=10;"
+ sql "delete from test_par_gen_col_unique partition p2 where c=12 and a=10;"
qt_delete_where_gen_col_and_other_col_select_unique "select * from test_par_gen_col_unique order by a,b,c;"
- qt_delete_query """delete from test_par_gen_col_unique t1 using test_par_gen_col t2 inner join test_par_gen_col t3
+ sql """delete from test_par_gen_col_unique t1 using test_par_gen_col t2 inner join test_par_gen_col t3
on t2.b=t3.b where t1.c=t2.c and t1.b=t2.b"""
qt_delete_query_select "select * from test_par_gen_col_unique order by a,b,c;"
sql "insert into test_par_gen_col_unique values(1,2,default),(10,2,default),(2,22,default),(10,2,default);"
- qt_delete_query_cte """
+ sql """
with cte as(
select t2.* from
test_par_gen_col t2 inner join test_par_gen_col t3 on t2.b=t3.b
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org