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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
