You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by kx...@apache.org on 2023/06/09 16:17:55 UTC
[doris] 03/13: [fix](regression) unique_with_mow_p2/test_pk_uk_case (#20497)
This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0-beta
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 56a6d566d9c45824631e0303eb8fe449e688e3bc
Author: zhannngchen <48...@users.noreply.github.com>
AuthorDate: Wed Jun 7 21:34:34 2023 +0800
[fix](regression) unique_with_mow_p2/test_pk_uk_case (#20497)
---
.../inverted_index_p0/unique_with_mow/test_pk_uk_case.groovy | 7 ++-----
regression-test/suites/unique_with_mow_p0/test_pk_uk_case.groovy | 9 +++------
regression-test/suites/unique_with_mow_p2/test_pk_uk_case.groovy | 7 ++-----
3 files changed, 7 insertions(+), 16 deletions(-)
diff --git a/regression-test/suites/inverted_index_p0/unique_with_mow/test_pk_uk_case.groovy b/regression-test/suites/inverted_index_p0/unique_with_mow/test_pk_uk_case.groovy
index 2f1487a822..fbf4e3a95e 100644
--- a/regression-test/suites/inverted_index_p0/unique_with_mow/test_pk_uk_case.groovy
+++ b/regression-test/suites/inverted_index_p0/unique_with_mow/test_pk_uk_case.groovy
@@ -93,7 +93,8 @@ suite("test_pk_uk_case", "inverted_index") {
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 1
PROPERTIES (
- "replication_num" = "1"
+ "replication_num" = "1",
+ "enable_unique_key_merge_on_write" = "false"
)
"""
@@ -212,8 +213,6 @@ suite("test_pk_uk_case", "inverted_index") {
count(*) AS count_order
FROM
${tableNamePk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
@@ -234,8 +233,6 @@ suite("test_pk_uk_case", "inverted_index") {
count(*) AS count_order
FROM
${tableNameUk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
diff --git a/regression-test/suites/unique_with_mow_p0/test_pk_uk_case.groovy b/regression-test/suites/unique_with_mow_p0/test_pk_uk_case.groovy
index 02fb51a30b..410e209721 100644
--- a/regression-test/suites/unique_with_mow_p0/test_pk_uk_case.groovy
+++ b/regression-test/suites/unique_with_mow_p0/test_pk_uk_case.groovy
@@ -86,8 +86,9 @@ suite("test_pk_uk_case") {
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 1
PROPERTIES (
- "replication_num" = "1"
- )
+ "replication_num" = "1",
+ "enable_unique_key_merge_on_write" = "false"
+ )
"""
Random rd = new Random()
@@ -205,8 +206,6 @@ suite("test_pk_uk_case") {
count(*) AS count_order
FROM
${tableNamePk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
@@ -227,8 +226,6 @@ suite("test_pk_uk_case") {
count(*) AS count_order
FROM
${tableNameUk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
diff --git a/regression-test/suites/unique_with_mow_p2/test_pk_uk_case.groovy b/regression-test/suites/unique_with_mow_p2/test_pk_uk_case.groovy
index 3739ed25af..4e9ab47a48 100644
--- a/regression-test/suites/unique_with_mow_p2/test_pk_uk_case.groovy
+++ b/regression-test/suites/unique_with_mow_p2/test_pk_uk_case.groovy
@@ -86,7 +86,8 @@ suite("test_pk_uk_case") {
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 1
PROPERTIES (
- "replication_num" = "1"
+ "replication_num" = "1",
+ "enable_unique_key_merge_on_write" = "false"
)
"""
@@ -205,8 +206,6 @@ suite("test_pk_uk_case") {
count(*) AS count_order
FROM
${tableNamePk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
@@ -227,8 +226,6 @@ suite("test_pk_uk_case") {
count(*) AS count_order
FROM
${tableNameUk}
- WHERE
- l_shipdate <= DATE '2023-01-01' - INTERVAL '90' DAY
GROUP BY
l_returnflag,
l_linestatus
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org