This is an automated email from the ASF dual-hosted git repository.
wenchen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new bc9fdeb9dd4 [SPARK-39316][FOLLOWUP][SQL][TESTS] Update q83.ansi golden
files result
bc9fdeb9dd4 is described below
commit bc9fdeb9dd411390979c9c037ed365afc378dea7
Author: Yuming Wang <yumw...@ebay.com>
AuthorDate: Mon Jun 13 18:35:36 2022 +0800
[SPARK-39316][FOLLOWUP][SQL][TESTS] Update q83.ansi golden files result
### What changes were proposed in this pull request?
Re-generate golden files:
```
SPARK_GENERATE_GOLDEN_FILES=1 SPARK_ANSI_SQL_MODE=true build/sbt
"sql/testOnly *PlanStability*Suite"
```
### Why are the changes needed?
To make tests pass with ANSI mode.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
N/A
Closes #36853 from wangyum/SPARK-39316.
Authored-by: Yuming Wang <yumw...@ebay.com>
Signed-off-by: Wenchen Fan <wenc...@databricks.com>
---
.../tpcds-plan-stability/approved-plans-v1_4/q83.ansi/explain.txt | 2 +-
.../tpcds-plan-stability/approved-plans-v1_4/q83.sf100.ansi/explain.txt | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git
a/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.ansi/explain.txt
b/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.ansi/explain.txt
index 003e5e62ba0..d281e59c727 100644
---
a/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.ansi/explain.txt
+++
b/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.ansi/explain.txt
@@ -256,7 +256,7 @@ Right keys [1]: [item_id#33]
Join condition: None
(45) Project [codegen id : 18]
-Output [8]: [item_id#11, sr_item_qty#12, (((cast(sr_item_qty#12 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS sr_dev#35, cr_item_qty#23, (((cast(cr_item_qty#23 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS cr_dev#36, wr_item_qty#34, (((cast(wr_item_qty#34 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS wr_dev#37, CheckOverfl [...]
+Output [8]: [item_id#11, sr_item_qty#12, (((cast(sr_item_qty#12 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS sr_dev#35, cr_item_qty#23, (((cast(cr_item_qty#23 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS cr_dev#36, wr_item_qty#34, (((cast(wr_item_qty#34 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS wr_dev#37, (cast(((sr_ [...]
Input [5]: [item_id#11, sr_item_qty#12, cr_item_qty#23, item_id#33,
wr_item_qty#34]
(46) TakeOrderedAndProject
diff --git
a/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.sf100.ansi/explain.txt
b/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.sf100.ansi/explain.txt
index d4e45fedc67..885aace0dc8 100644
---
a/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.sf100.ansi/explain.txt
+++
b/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.sf100.ansi/explain.txt
@@ -256,7 +256,7 @@ Right keys [1]: [item_id#33]
Join condition: None
(45) Project [codegen id : 18]
-Output [8]: [item_id#11, sr_item_qty#12, (((cast(sr_item_qty#12 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS sr_dev#35, cr_item_qty#23, (((cast(cr_item_qty#23 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS cr_dev#36, wr_item_qty#34, (((cast(wr_item_qty#34 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS wr_dev#37, CheckOverfl [...]
+Output [8]: [item_id#11, sr_item_qty#12, (((cast(sr_item_qty#12 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS sr_dev#35, cr_item_qty#23, (((cast(cr_item_qty#23 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS cr_dev#36, wr_item_qty#34, (((cast(wr_item_qty#34 as double) /
cast(((sr_item_qty#12 + cr_item_qty#23) + wr_item_qty#34) as double)) / 3.0) *
100.0) AS wr_dev#37, (cast(((sr_ [...]
Input [5]: [item_id#11, sr_item_qty#12, cr_item_qty#23, item_id#33,
wr_item_qty#34]
(46) TakeOrderedAndProject
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
