This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch branch-2.0-alpha in repository https://gitbox.apache.org/repos/asf/doris.git
commit d1f480dd5d2f93160a676e8c93059c16750c16d8 Author: Gabriel <[email protected]> AuthorDate: Thu Apr 20 15:49:58 2023 +0800 [test](fix) Fix invalid decimal type in regresion test cases (#18844) --- regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q31.sql | 4 ++-- regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q53.sql | 2 +- regression-test/suites/tpcds_sf1000_p2/sql/q31.sql | 4 ++-- regression-test/suites/tpcds_sf1000_p2/sql/q53.sql | 2 +- regression-test/suites/tpcds_sf100_p2/sql/q31.sql | 4 ++-- regression-test/suites/tpcds_sf100_p2/sql/q53.sql | 2 +- regression-test/suites/tpcds_sf1_p1/sql/q31.sql | 4 ++-- regression-test/suites/tpcds_sf1_p1/sql/q53.sql | 2 +- regression-test/suites/tpcds_sf1_unique_p1/sql/q31.sql | 4 ++-- regression-test/suites/tpcds_sf1_unique_p1/sql/q53.sql | 2 +- 10 files changed, 15 insertions(+), 15 deletions(-) diff --git a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q31.sql b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q31.sql index 28becfabd6..292413cb8b 100644 --- a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q31.sql +++ b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q31.sql @@ -58,6 +58,6 @@ WHERE (ss1.d_qoy = 1) AND (ws1.ca_county = ws3.ca_county) AND (ws3.d_qoy = 3) AND (ws3.d_year = 2000) - AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(27,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(27,3)) / ss1.store_sales) ELSE null END)) - AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(27,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(27,3)) / ss2.store_sales) ELSE null END)) + AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(21,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(21,3)) / ss1.store_sales) ELSE null END)) + AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(21,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(21,3)) / ss2.store_sales) ELSE null END)) ORDER BY ss1.ca_county ASC diff --git a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q53.sql b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q53.sql index d62e53c01b..4689f6ffe6 100644 --- a/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q53.sql +++ b/regression-test/suites/inverted_index_p1/tpcds_sf1_index/sql/q53.sql @@ -22,6 +22,6 @@ FROM AND (i_brand IN ('amalgimporto #1' , 'edu packscholar #1' , 'exportiimporto #1' , 'importoamalg #1')))) GROUP BY i_manufact_id, d_qoy ) tmp1 -WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(27,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) +WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(22,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) ORDER BY avg_quarterly_sales ASC, sum_sales ASC, i_manufact_id ASC LIMIT 100 diff --git a/regression-test/suites/tpcds_sf1000_p2/sql/q31.sql b/regression-test/suites/tpcds_sf1000_p2/sql/q31.sql index 28becfabd6..292413cb8b 100644 --- a/regression-test/suites/tpcds_sf1000_p2/sql/q31.sql +++ b/regression-test/suites/tpcds_sf1000_p2/sql/q31.sql @@ -58,6 +58,6 @@ WHERE (ss1.d_qoy = 1) AND (ws1.ca_county = ws3.ca_county) AND (ws3.d_qoy = 3) AND (ws3.d_year = 2000) - AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(27,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(27,3)) / ss1.store_sales) ELSE null END)) - AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(27,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(27,3)) / ss2.store_sales) ELSE null END)) + AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(21,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(21,3)) / ss1.store_sales) ELSE null END)) + AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(21,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(21,3)) / ss2.store_sales) ELSE null END)) ORDER BY ss1.ca_county ASC diff --git a/regression-test/suites/tpcds_sf1000_p2/sql/q53.sql b/regression-test/suites/tpcds_sf1000_p2/sql/q53.sql index d62e53c01b..4689f6ffe6 100644 --- a/regression-test/suites/tpcds_sf1000_p2/sql/q53.sql +++ b/regression-test/suites/tpcds_sf1000_p2/sql/q53.sql @@ -22,6 +22,6 @@ FROM AND (i_brand IN ('amalgimporto #1' , 'edu packscholar #1' , 'exportiimporto #1' , 'importoamalg #1')))) GROUP BY i_manufact_id, d_qoy ) tmp1 -WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(27,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) +WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(22,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) ORDER BY avg_quarterly_sales ASC, sum_sales ASC, i_manufact_id ASC LIMIT 100 diff --git a/regression-test/suites/tpcds_sf100_p2/sql/q31.sql b/regression-test/suites/tpcds_sf100_p2/sql/q31.sql index ccb61dec51..1ed195ad0d 100644 --- a/regression-test/suites/tpcds_sf100_p2/sql/q31.sql +++ b/regression-test/suites/tpcds_sf100_p2/sql/q31.sql @@ -58,6 +58,6 @@ WHERE (ss1.d_qoy = 1) AND (ws1.ca_county = ws3.ca_county) AND (ws3.d_qoy = 3) AND (ws3.d_year = 2000) - AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(27,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(27,3)) / ss1.store_sales) ELSE null END)) - AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(27,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(27,3)) / ss2.store_sales) ELSE null END)) + AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(21,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(21,3)) / ss1.store_sales) ELSE null END)) + AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(21,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(21,3)) / ss2.store_sales) ELSE null END)) ORDER BY ss1.ca_county ASC; diff --git a/regression-test/suites/tpcds_sf100_p2/sql/q53.sql b/regression-test/suites/tpcds_sf100_p2/sql/q53.sql index 7abdffc3e3..3126b61061 100644 --- a/regression-test/suites/tpcds_sf100_p2/sql/q53.sql +++ b/regression-test/suites/tpcds_sf100_p2/sql/q53.sql @@ -22,6 +22,6 @@ FROM AND (i_brand IN ('amalgimporto #1' , 'edu packscholar #1' , 'exportiimporto #1' , 'importoamalg #1')))) GROUP BY i_manufact_id, d_qoy ) tmp1 -WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(27,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(10,2))) +WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(22,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(10,2))) ORDER BY avg_quarterly_sales ASC, sum_sales ASC, i_manufact_id ASC LIMIT 100; diff --git a/regression-test/suites/tpcds_sf1_p1/sql/q31.sql b/regression-test/suites/tpcds_sf1_p1/sql/q31.sql index 28becfabd6..292413cb8b 100644 --- a/regression-test/suites/tpcds_sf1_p1/sql/q31.sql +++ b/regression-test/suites/tpcds_sf1_p1/sql/q31.sql @@ -58,6 +58,6 @@ WHERE (ss1.d_qoy = 1) AND (ws1.ca_county = ws3.ca_county) AND (ws3.d_qoy = 3) AND (ws3.d_year = 2000) - AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(27,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(27,3)) / ss1.store_sales) ELSE null END)) - AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(27,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(27,3)) / ss2.store_sales) ELSE null END)) + AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(21,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(21,3)) / ss1.store_sales) ELSE null END)) + AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(21,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(21,3)) / ss2.store_sales) ELSE null END)) ORDER BY ss1.ca_county ASC diff --git a/regression-test/suites/tpcds_sf1_p1/sql/q53.sql b/regression-test/suites/tpcds_sf1_p1/sql/q53.sql index d62e53c01b..4689f6ffe6 100644 --- a/regression-test/suites/tpcds_sf1_p1/sql/q53.sql +++ b/regression-test/suites/tpcds_sf1_p1/sql/q53.sql @@ -22,6 +22,6 @@ FROM AND (i_brand IN ('amalgimporto #1' , 'edu packscholar #1' , 'exportiimporto #1' , 'importoamalg #1')))) GROUP BY i_manufact_id, d_qoy ) tmp1 -WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(27,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) +WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(22,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) ORDER BY avg_quarterly_sales ASC, sum_sales ASC, i_manufact_id ASC LIMIT 100 diff --git a/regression-test/suites/tpcds_sf1_unique_p1/sql/q31.sql b/regression-test/suites/tpcds_sf1_unique_p1/sql/q31.sql index 28becfabd6..292413cb8b 100644 --- a/regression-test/suites/tpcds_sf1_unique_p1/sql/q31.sql +++ b/regression-test/suites/tpcds_sf1_unique_p1/sql/q31.sql @@ -58,6 +58,6 @@ WHERE (ss1.d_qoy = 1) AND (ws1.ca_county = ws3.ca_county) AND (ws3.d_qoy = 3) AND (ws3.d_year = 2000) - AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(27,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(27,3)) / ss1.store_sales) ELSE null END)) - AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(27,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(27,3)) / ss2.store_sales) ELSE null END)) + AND ((CASE WHEN (ws1.web_sales > 0) THEN (CAST(ws2.web_sales AS DECIMAL(21,3)) / ws1.web_sales) ELSE null END) > (CASE WHEN (ss1.store_sales > 0) THEN (CAST(ss2.store_sales AS DECIMAL(21,3)) / ss1.store_sales) ELSE null END)) + AND ((CASE WHEN (ws2.web_sales > 0) THEN (CAST(ws3.web_sales AS DECIMAL(21,3)) / ws2.web_sales) ELSE null END) > (CASE WHEN (ss2.store_sales > 0) THEN (CAST(ss3.store_sales AS DECIMAL(21,3)) / ss2.store_sales) ELSE null END)) ORDER BY ss1.ca_county ASC diff --git a/regression-test/suites/tpcds_sf1_unique_p1/sql/q53.sql b/regression-test/suites/tpcds_sf1_unique_p1/sql/q53.sql index d62e53c01b..4689f6ffe6 100644 --- a/regression-test/suites/tpcds_sf1_unique_p1/sql/q53.sql +++ b/regression-test/suites/tpcds_sf1_unique_p1/sql/q53.sql @@ -22,6 +22,6 @@ FROM AND (i_brand IN ('amalgimporto #1' , 'edu packscholar #1' , 'exportiimporto #1' , 'importoamalg #1')))) GROUP BY i_manufact_id, d_qoy ) tmp1 -WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(27,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) +WHERE ((CASE WHEN (avg_quarterly_sales > 0) THEN (abs((CAST(sum_sales AS DECIMAL(22,4)) - avg_quarterly_sales)) / avg_quarterly_sales) ELSE null END) > CAST('0.1' AS DECIMAL(2,1))) ORDER BY avg_quarterly_sales ASC, sum_sales ASC, i_manufact_id ASC LIMIT 100 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
