This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 7033a21c20c [regression-test](fix) fix tpcds q24 query and result
(#51497)
7033a21c20c is described below
commit 7033a21c20c675f99b009e4f89727c2b66b98a1c
Author: shuke <[email protected]>
AuthorDate: Mon Jun 9 11:42:59 2025 +0800
[regression-test](fix) fix tpcds q24 query and result (#51497)
### What problem does this PR solve?
tpcds query 24 are not right before, fix it.
---
.../inverted_index_p1/tpcds_sf1_index/sql/q24_1.out | Bin 307 -> 109 bytes
.../inverted_index_p1/tpcds_sf1_index/sql/q24_2.out | Bin 137 -> 109 bytes
.../tpcds_sf100_dup_without_key_p2/sql/q24_1.out | Bin 27654 -> 1496 bytes
.../tpcds_sf100_dup_without_key_p2/sql/q24_2.out | Bin 3795 -> 188 bytes
regression-test/data/tpcds_sf100_p2/sql/q24_1.out | Bin 27654 -> 1496 bytes
regression-test/data/tpcds_sf100_p2/sql/q24_2.out | Bin 3795 -> 188 bytes
regression-test/data/tpcds_sf1_p1/sql/q24_1.out | Bin 307 -> 109 bytes
regression-test/data/tpcds_sf1_p1/sql/q24_2.out | Bin 137 -> 109 bytes
.../data/tpcds_sf1_unique_ck_p1/sql/q24_1.out | Bin 307 -> 109 bytes
.../data/tpcds_sf1_unique_ck_p1/sql/q24_2.out | Bin 137 -> 109 bytes
.../data/tpcds_sf1_unique_p1/sql/q24_1.out | Bin 307 -> 109 bytes
.../data/tpcds_sf1_unique_p1/sql/q24_2.out | Bin 137 -> 109 bytes
.../inverted_index_p1/tpcds_sf1_index/sql/q24_1.sql | 2 +-
.../inverted_index_p1/tpcds_sf1_index/sql/q24_2.sql | 2 +-
.../tpcds_sf100_dup_without_key_p2/sql/q24_1.sql | 2 +-
.../tpcds_sf100_dup_without_key_p2/sql/q24_2.sql | 2 +-
regression-test/suites/tpcds_sf100_p2/sql/q24_1.sql | 2 +-
regression-test/suites/tpcds_sf100_p2/sql/q24_2.sql | 2 +-
regression-test/suites/tpcds_sf1_p1/sql/q24_1.sql | 2 +-
regression-test/suites/tpcds_sf1_p1/sql/q24_2.sql | 2 +-
.../suites/tpcds_sf1_unique_ck_p1/sql/q24_1.sql | 2 +-
.../suites/tpcds_sf1_unique_ck_p1/sql/q24_2.sql | 2 +-
.../suites/tpcds_sf1_unique_p1/sql/q24_1.sql | 2 +-
.../suites/tpcds_sf1_unique_p1/sql/q24_2.sql | 2 +-
24 files changed, 12 insertions(+), 12 deletions(-)
diff --git
a/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_1.out
b/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_1.out
index b5b3781427f..a87a3f6eb2f 100644
Binary files
a/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_1.out and
b/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_1.out differ
diff --git
a/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_2.out
b/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_2.out
index 3dd7690d52b..04afb1f4cd5 100644
Binary files
a/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_2.out and
b/regression-test/data/inverted_index_p1/tpcds_sf1_index/sql/q24_2.out differ
diff --git a/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_1.out
b/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_1.out
index 2a91a6a701a..239f109f792 100644
Binary files
a/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_1.out and
b/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_1.out differ
diff --git a/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_2.out
b/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_2.out
index dd0227eea25..aa16345d4d5 100644
Binary files
a/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_2.out and
b/regression-test/data/tpcds_sf100_dup_without_key_p2/sql/q24_2.out differ
diff --git a/regression-test/data/tpcds_sf100_p2/sql/q24_1.out
b/regression-test/data/tpcds_sf100_p2/sql/q24_1.out
index 2a91a6a701a..239f109f792 100644
Binary files a/regression-test/data/tpcds_sf100_p2/sql/q24_1.out and
b/regression-test/data/tpcds_sf100_p2/sql/q24_1.out differ
diff --git a/regression-test/data/tpcds_sf100_p2/sql/q24_2.out
b/regression-test/data/tpcds_sf100_p2/sql/q24_2.out
index dd0227eea25..aa16345d4d5 100644
Binary files a/regression-test/data/tpcds_sf100_p2/sql/q24_2.out and
b/regression-test/data/tpcds_sf100_p2/sql/q24_2.out differ
diff --git a/regression-test/data/tpcds_sf1_p1/sql/q24_1.out
b/regression-test/data/tpcds_sf1_p1/sql/q24_1.out
index b5b3781427f..a87a3f6eb2f 100644
Binary files a/regression-test/data/tpcds_sf1_p1/sql/q24_1.out and
b/regression-test/data/tpcds_sf1_p1/sql/q24_1.out differ
diff --git a/regression-test/data/tpcds_sf1_p1/sql/q24_2.out
b/regression-test/data/tpcds_sf1_p1/sql/q24_2.out
index 3dd7690d52b..04afb1f4cd5 100644
Binary files a/regression-test/data/tpcds_sf1_p1/sql/q24_2.out and
b/regression-test/data/tpcds_sf1_p1/sql/q24_2.out differ
diff --git a/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_1.out
b/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_1.out
index b5b3781427f..a87a3f6eb2f 100644
Binary files a/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_1.out and
b/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_1.out differ
diff --git a/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_2.out
b/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_2.out
index 3dd7690d52b..04afb1f4cd5 100644
Binary files a/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_2.out and
b/regression-test/data/tpcds_sf1_unique_ck_p1/sql/q24_2.out differ
diff --git a/regression-test/data/tpcds_sf1_unique_p1/sql/q24_1.out
b/regression-test/data/tpcds_sf1_unique_p1/sql/q24_1.out
index b5b3781427f..a87a3f6eb2f 100644
Binary files a/regression-test/data/tpcds_sf1_unique_p1/sql/q24_1.out and
b/regression-test/data/tpcds_sf1_unique_p1/sql/q24_1.out differ
diff --git a/regression-test/data/tpcds_sf1_unique_p1/sql/q24_2.out
b/regression-test/data/tpcds_sf1_unique_p1/sql/q24_2.out
index 3dd7690d52b..04afb1f4cd5 100644
Binary files a/regression-test/data/tpcds_sf1_unique_p1/sql/q24_2.out and
b/regression-test/data/tpcds_sf1_unique_p1/sql/q24_2.out differ
diff --git
a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_1.sql
b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_1.sql
index 1f9cf6888dd..7dd33b66803 100644
--- a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_1.sql
+++ b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git
a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_2.sql
b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_2.sql
index b89577eac86..90770946c0c 100644
--- a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_2.sql
+++ b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git
a/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_1.sql
b/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_1.sql
index 18e674f4993..d504d784da9 100644
--- a/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_1.sql
+++ b/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
and c_current_addr_sk = ca_address_sk
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git
a/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_2.sql
b/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_2.sql
index 6873a56b4af..c4efb602430 100644
--- a/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_2.sql
+++ b/regression-test/suites/tpcds_sf100_dup_without_key_p2/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf100_p2/sql/q24_1.sql
b/regression-test/suites/tpcds_sf100_p2/sql/q24_1.sql
index 52f3ee657da..89b4e0b9e49 100644
--- a/regression-test/suites/tpcds_sf100_p2/sql/q24_1.sql
+++ b/regression-test/suites/tpcds_sf100_p2/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf100_p2/sql/q24_2.sql
b/regression-test/suites/tpcds_sf100_p2/sql/q24_2.sql
index 6873a56b4af..c4efb602430 100644
--- a/regression-test/suites/tpcds_sf100_p2/sql/q24_2.sql
+++ b/regression-test/suites/tpcds_sf100_p2/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_p1/sql/q24_1.sql
b/regression-test/suites/tpcds_sf1_p1/sql/q24_1.sql
index 1f9cf6888dd..7dd33b66803 100644
--- a/regression-test/suites/tpcds_sf1_p1/sql/q24_1.sql
+++ b/regression-test/suites/tpcds_sf1_p1/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_p1/sql/q24_2.sql
b/regression-test/suites/tpcds_sf1_p1/sql/q24_2.sql
index b89577eac86..90770946c0c 100644
--- a/regression-test/suites/tpcds_sf1_p1/sql/q24_2.sql
+++ b/regression-test/suites/tpcds_sf1_p1/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_1.sql
b/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_1.sql
index 1f9cf6888dd..7dd33b66803 100644
--- a/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_1.sql
+++ b/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_2.sql
b/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_2.sql
index b89577eac86..90770946c0c 100644
--- a/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_2.sql
+++ b/regression-test/suites/tpcds_sf1_unique_ck_p1/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_1.sql
b/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_1.sql
index 1f9cf6888dd..7dd33b66803 100644
--- a/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_1.sql
+++ b/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_1.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
diff --git a/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_2.sql
b/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_2.sql
index b89577eac86..90770946c0c 100644
--- a/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_2.sql
+++ b/regression-test/suites/tpcds_sf1_unique_p1/sql/q24_2.sql
@@ -25,7 +25,7 @@ WITH
AND (ss_item_sk = i_item_sk)
AND (ss_store_sk = s_store_sk)
AND (c_current_addr_sk = ca_address_sk)
- AND (c_birth_country = upper(ca_country))
+ AND (c_birth_country <> upper(ca_country))
AND (s_zip = ca_zip)
AND (s_market_id = 8)
GROUP BY c_last_name, c_first_name, s_store_name, ca_state, s_state,
i_color, i_current_price, i_manager_id, i_units, i_size
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
