You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2023/04/20 10:10:52 UTC
[doris] 05/06: [test](fix) Fix invalid decimal type in regresion test cases (#18844)
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 <ga...@gmail.com>
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: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org