Skip to content

Commit 0d45567

Browse files
MaxGekkMaxGekk
committed
Re-gen results for PlanStabilityWithStatsSuite
1 parent 39d33c9 commit 0d45567

File tree

23 files changed

+44
-44
lines changed

23 files changed

+44
-44
lines changed

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q12.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -86,15 +86,15 @@ Input [9]: [ws_item_sk#1, ws_ext_sales_price#2, ws_sold_date_sk#3, i_item_sk#6,
8686
Output [2]: [d_date_sk#13, d_date#14]
8787
Batched: true
8888
Location [not included in comparison]/{warehouse_dir}/date_dim]
89-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,1999-02-22), LessThanOrEqual(d_date,1999-03-24), IsNotNull(d_date_sk)]
89+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,1999-02-22), IsNotNull(d_date_sk)]
9090
ReadSchema: struct<d_date_sk:int,d_date:date>
9191

9292
(14) ColumnarToRow [codegen id : 5]
9393
Input [2]: [d_date_sk#13, d_date#14]
9494

9595
(15) Filter [codegen id : 5]
9696
Input [2]: [d_date_sk#13, d_date#14]
97-
Condition : (((isnotnull(d_date#14) AND (d_date#14 >= 1999-02-22)) AND (d_date#14 <= 1999-03-24)) AND isnotnull(d_date_sk#13))
97+
Condition : (((isnotnull(d_date#14) AND (d_date#14 >= 1999-02-22)) AND (cast(d_date#14 as timestamp) <= 1999-03-24 00:00:00)) AND isnotnull(d_date_sk#13))
9898

9999
(16) Project [codegen id : 5]
100100
Output [1]: [d_date_sk#13]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -195,15 +195,15 @@ Input [6]: [cs_ship_date_sk#1, cs_call_center_sk#3, cs_order_number#5, cs_ext_sh
195195
Output [2]: [d_date_sk#23, d_date#24]
196196
Batched: true
197197
Location [not included in comparison]/{warehouse_dir}/date_dim]
198-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2002-02-01), LessThanOrEqual(d_date,2002-04-02), IsNotNull(d_date_sk)]
198+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2002-02-01), IsNotNull(d_date_sk)]
199199
ReadSchema: struct<d_date_sk:int,d_date:date>
200200

201201
(35) ColumnarToRow [codegen id : 10]
202202
Input [2]: [d_date_sk#23, d_date#24]
203203

204204
(36) Filter [codegen id : 10]
205205
Input [2]: [d_date_sk#23, d_date#24]
206-
Condition : (((isnotnull(d_date#24) AND (d_date#24 >= 2002-02-01)) AND (d_date#24 <= 2002-04-02)) AND isnotnull(d_date_sk#23))
206+
Condition : (((isnotnull(d_date#24) AND (d_date#24 >= 2002-02-01)) AND (cast(d_date#24 as timestamp) <= 2002-04-02 00:00:00)) AND isnotnull(d_date_sk#23))
207207

208208
(37) Project [codegen id : 10]
209209
Output [1]: [d_date_sk#23]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q20.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -86,15 +86,15 @@ Input [9]: [cs_item_sk#1, cs_ext_sales_price#2, cs_sold_date_sk#3, i_item_sk#6,
8686
Output [2]: [d_date_sk#13, d_date#14]
8787
Batched: true
8888
Location [not included in comparison]/{warehouse_dir}/date_dim]
89-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,1999-02-22), LessThanOrEqual(d_date,1999-03-24), IsNotNull(d_date_sk)]
89+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,1999-02-22), IsNotNull(d_date_sk)]
9090
ReadSchema: struct<d_date_sk:int,d_date:date>
9191

9292
(14) ColumnarToRow [codegen id : 5]
9393
Input [2]: [d_date_sk#13, d_date#14]
9494

9595
(15) Filter [codegen id : 5]
9696
Input [2]: [d_date_sk#13, d_date#14]
97-
Condition : (((isnotnull(d_date#14) AND (d_date#14 >= 1999-02-22)) AND (d_date#14 <= 1999-03-24)) AND isnotnull(d_date_sk#13))
97+
Condition : (((isnotnull(d_date#14) AND (d_date#14 >= 1999-02-22)) AND (cast(d_date#14 as timestamp) <= 1999-03-24 00:00:00)) AND isnotnull(d_date_sk#13))
9898

9999
(16) Project [codegen id : 5]
100100
Output [1]: [d_date_sk#13]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q21.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -78,15 +78,15 @@ Input [6]: [inv_item_sk#1, inv_warehouse_sk#2, inv_quantity_on_hand#3, inv_date_
7878
Output [2]: [d_date_sk#10, d_date#11]
7979
Batched: true
8080
Location [not included in comparison]/{warehouse_dir}/date_dim]
81-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-02-10), LessThanOrEqual(d_date,2000-04-10), IsNotNull(d_date_sk)]
81+
PushedFilters: [IsNotNull(d_date), IsNotNull(d_date_sk)]
8282
ReadSchema: struct<d_date_sk:int,d_date:date>
8383

8484
(12) ColumnarToRow [codegen id : 2]
8585
Input [2]: [d_date_sk#10, d_date#11]
8686

8787
(13) Filter [codegen id : 2]
8888
Input [2]: [d_date_sk#10, d_date#11]
89-
Condition : (((isnotnull(d_date#11) AND (d_date#11 >= 2000-02-10)) AND (d_date#11 <= 2000-04-10)) AND isnotnull(d_date_sk#10))
89+
Condition : (((isnotnull(d_date#11) AND (cast(d_date#11 as timestamp) >= 2000-02-10 00:00:00)) AND (cast(d_date#11 as timestamp) <= 2000-04-10 00:00:00)) AND isnotnull(d_date_sk#10))
9090

9191
(14) BroadcastExchange
9292
Input [2]: [d_date_sk#10, d_date#11]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q32.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -73,15 +73,15 @@ Condition : isnotnull(cs_item_sk#4)
7373
Output [2]: [d_date_sk#8, d_date#9]
7474
Batched: true
7575
Location [not included in comparison]/{warehouse_dir}/date_dim]
76-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-01-27), LessThanOrEqual(d_date,2000-04-26), IsNotNull(d_date_sk)]
76+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-01-27), IsNotNull(d_date_sk)]
7777
ReadSchema: struct<d_date_sk:int,d_date:date>
7878

7979
(10) ColumnarToRow [codegen id : 2]
8080
Input [2]: [d_date_sk#8, d_date#9]
8181

8282
(11) Filter [codegen id : 2]
8383
Input [2]: [d_date_sk#8, d_date#9]
84-
Condition : (((isnotnull(d_date#9) AND (d_date#9 >= 2000-01-27)) AND (d_date#9 <= 2000-04-26)) AND isnotnull(d_date_sk#8))
84+
Condition : (((isnotnull(d_date#9) AND (d_date#9 >= 2000-01-27)) AND (cast(d_date#9 as timestamp) <= 2000-04-26 00:00:00)) AND isnotnull(d_date_sk#8))
8585

8686
(12) Project [codegen id : 2]
8787
Output [1]: [d_date_sk#8]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q37.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -87,15 +87,15 @@ Input [6]: [i_item_sk#1, i_item_id#2, i_item_desc#3, i_current_price#4, inv_item
8787
Output [2]: [d_date_sk#11, d_date#12]
8888
Batched: true
8989
Location [not included in comparison]/{warehouse_dir}/date_dim]
90-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-02-01), LessThanOrEqual(d_date,2000-04-01), IsNotNull(d_date_sk)]
90+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-02-01), IsNotNull(d_date_sk)]
9191
ReadSchema: struct<d_date_sk:int,d_date:date>
9292

9393
(13) ColumnarToRow [codegen id : 2]
9494
Input [2]: [d_date_sk#11, d_date#12]
9595

9696
(14) Filter [codegen id : 2]
9797
Input [2]: [d_date_sk#11, d_date#12]
98-
Condition : (((isnotnull(d_date#12) AND (d_date#12 >= 2000-02-01)) AND (d_date#12 <= 2000-04-01)) AND isnotnull(d_date_sk#11))
98+
Condition : (((isnotnull(d_date#12) AND (d_date#12 >= 2000-02-01)) AND (cast(d_date#12 as timestamp) <= 2000-04-01 00:00:00)) AND isnotnull(d_date_sk#11))
9999

100100
(15) Project [codegen id : 2]
101101
Output [1]: [d_date_sk#11]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q40.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -130,15 +130,15 @@ Input [7]: [cs_warehouse_sk#1, cs_item_sk#2, cs_sales_price#4, cs_sold_date_sk#5
130130
Output [2]: [d_date_sk#17, d_date#18]
131131
Batched: true
132132
Location [not included in comparison]/{warehouse_dir}/date_dim]
133-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-02-10), LessThanOrEqual(d_date,2000-04-10), IsNotNull(d_date_sk)]
133+
PushedFilters: [IsNotNull(d_date), IsNotNull(d_date_sk)]
134134
ReadSchema: struct<d_date_sk:int,d_date:date>
135135

136136
(22) ColumnarToRow [codegen id : 6]
137137
Input [2]: [d_date_sk#17, d_date#18]
138138

139139
(23) Filter [codegen id : 6]
140140
Input [2]: [d_date_sk#17, d_date#18]
141-
Condition : (((isnotnull(d_date#18) AND (d_date#18 >= 2000-02-10)) AND (d_date#18 <= 2000-04-10)) AND isnotnull(d_date_sk#17))
141+
Condition : (((isnotnull(d_date#18) AND (cast(d_date#18 as timestamp) >= 2000-02-10 00:00:00)) AND (cast(d_date#18 as timestamp) <= 2000-04-10 00:00:00)) AND isnotnull(d_date_sk#17))
142142

143143
(24) BroadcastExchange
144144
Input [2]: [d_date_sk#17, d_date#18]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q5.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -153,15 +153,15 @@ Input [8]: [store_sk#6, date_sk#7, sales_price#8, profit#9, return_amt#10, net_l
153153
Output [2]: [d_date_sk#25, d_date#26]
154154
Batched: true
155155
Location [not included in comparison]/{warehouse_dir}/date_dim]
156-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-08-23), LessThanOrEqual(d_date,2000-09-06), IsNotNull(d_date_sk)]
156+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-08-23), IsNotNull(d_date_sk)]
157157
ReadSchema: struct<d_date_sk:int,d_date:date>
158158

159159
(17) ColumnarToRow [codegen id : 4]
160160
Input [2]: [d_date_sk#25, d_date#26]
161161

162162
(18) Filter [codegen id : 4]
163163
Input [2]: [d_date_sk#25, d_date#26]
164-
Condition : (((isnotnull(d_date#26) AND (d_date#26 >= 2000-08-23)) AND (d_date#26 <= 2000-09-06)) AND isnotnull(d_date_sk#25))
164+
Condition : (((isnotnull(d_date#26) AND (d_date#26 >= 2000-08-23)) AND (cast(d_date#26 as timestamp) <= 2000-09-06 00:00:00)) AND isnotnull(d_date_sk#25))
165165

166166
(19) Project [codegen id : 4]
167167
Output [1]: [d_date_sk#25]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q72.sf100/explain.txt‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -276,7 +276,7 @@ Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint))
276276
(44) BroadcastHashJoin [codegen id : 10]
277277
Left keys [1]: [cs_sold_date_sk#8]
278278
Right keys [1]: [d_date_sk#23]
279-
Join condition: (d_date#17 > d_date#24 + 5 days)
279+
Join condition: (cast(d_date#17 as timestamp) > cast(d_date#24 as timestamp) + 432000000000)
280280

281281
(45) Project [codegen id : 10]
282282
Output [7]: [cs_item_sk#4, cs_promo_sk#5, cs_order_number#6, cs_quantity#7, i_item_desc#21, d_week_seq#25, d_date_sk#28]

‎sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q77.sf100/explain.txt‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -109,15 +109,15 @@ Condition : isnotnull(ss_store_sk#1)
109109
Output [2]: [d_date_sk#6, d_date#7]
110110
Batched: true
111111
Location [not included in comparison]/{warehouse_dir}/date_dim]
112-
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-08-03), LessThanOrEqual(d_date,2000-09-02), IsNotNull(d_date_sk)]
112+
PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2000-08-03), IsNotNull(d_date_sk)]
113113
ReadSchema: struct<d_date_sk:int,d_date:date>
114114

115115
(5) ColumnarToRow [codegen id : 1]
116116
Input [2]: [d_date_sk#6, d_date#7]
117117

118118
(6) Filter [codegen id : 1]
119119
Input [2]: [d_date_sk#6, d_date#7]
120-
Condition : (((isnotnull(d_date#7) AND (d_date#7 >= 2000-08-03)) AND (d_date#7 <= 2000-09-02)) AND isnotnull(d_date_sk#6))
120+
Condition : (((isnotnull(d_date#7) AND (d_date#7 >= 2000-08-03)) AND (cast(d_date#7 as timestamp) <= 2000-09-02 00:00:00)) AND isnotnull(d_date_sk#6))
121121

122122
(7) Project [codegen id : 1]
123123
Output [1]: [d_date_sk#6]

0 commit comments

Comments
 (0)