sunchao opened a new issue, #173:
URL: https://github.com/apache/arrow-datafusion-comet/issues/173
### Describe the bug
```
- Decimal random number tests *** FAILED *** (13 seconds, 743 milliseconds)
Results do not match for query:
Timezone:
sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]]
Timezone Env:
== Parsed Logical Plan ==
Project [a#325671, b#325672,
CheckOverflow((promote_precision(cast(a#325671 as decimal(38,38))) -
promote_precision(cast(b#325672 as decimal(38,38)))), DecimalType(38,38), true)
AS (a - b)#326112]
+- SubqueryAlias spark_catalog.default.test
+- Relation default.test[a#325671,b#325672] parquet
== Analyzed Logical Plan ==
a: decimal(2,1), b: decimal(38,38), (a - b): decimal(38,38)
Project [a#325671, b#325672,
CheckOverflow((promote_precision(cast(a#325671 as decimal(38,38))) -
promote_precision(cast(b#325672 as decimal(38,38)))), DecimalType(38,38), true)
AS (a - b)#326112]
+- SubqueryAlias spark_catalog.default.test
+- Relation default.test[a#325671,b#325672] parquet
== Optimized Logical Plan ==
Project [a#325671, b#325672,
CheckOverflow((promote_precision(cast(a#325671 as decimal(38,38))) -
promote_precision(b#325672)), DecimalType(38,38), true) AS (a - b)#326112]
+- Relation default.test[a#325671,b#325672] parquet
== Physical Plan ==
*(1) ColumnarToRow
+- CometProject [a#325671, b#325672, (a - b)#326112], [a#325671, b#325672,
CheckOverflow((promote_precision(cast(a#325671 as decimal(38,38))) -
promote_precision(b#325672)), DecimalType(38,38), true) AS (a - b)#326112]
+- CometScan parquet default.test[a#325671,b#325672] Batched: true,
DataFilters: [], Format: CometParquet, Location: InMemoryFileIndex(1
paths)[file:/__w/arrow-datafusion-comet/arrow-datafusion-comet/spark/spark-wa...,
PartitionFilters: [], PushedFilters: [], ReadSchema:
struct<a:decimal(2,1),b:decimal(38,38)>
== Results ==
== Results ==
!== Correct Answer - 10 == == Spark
Answer - 10 ==
struct<a:decimal(2,1),b:decimal(38,38),(a - b):decimal(38,38)>
struct<a:decimal(2,1),b:decimal(38,38),(a - b):decimal(38,38)>
[-2.6,0.88600364721046401251597348897522086930,null]
[-2.6,0.88600364721046401251597348897522086930,null]
[-3.6,0.68097743687614462304975873328530786952,null]
[-3.6,0.68097743687614462304975873328530786952,null]
[-5.1,-0.37863273217430690171859674909465279049,null]
[-5.1,-0.37863273217430690171859674909465279049,null]
[-5.3,-0.47519755834068424237294295838046447765,null]
[-5.3,-0.47519755834068424237294295838046447765,null]
[-9.1,-0.74891896573347542933545873802062354887,null]
[-9.1,-0.74891896573347542933545873802062354887,null]
![1.2,0.91535778148780061145041814952577179042,null]
[1.2,0.91535778148780061145041814952577179042,0.28464221851219938854958185047422820958]
[1.8,-0.12927780945480918011673642132004649336,null]
[1.8,-0.12927780945480918011673642132004649336,null]
[2.6,0.52799234656343101374245269285971578300,null]
[2.6,0.52799234656343101374245269285971578300,null]
[5.3,0.18652783899237759511765505532093031810,null]
[5.3,0.18652783899237759511765505532093031810,null]
[5.6,-0.20821543010358580985336043301037366767,null]
[5.6,-0.20821543010358580985336043301037366767,null] (QueryTest.scala:243)
```
### Steps to reproduce
_No response_
### Expected behavior
_No response_
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
