andygrove opened a new issue, #1506:
URL: https://github.com/apache/datafusion-comet/issues/1506
### Describe the bug
I saw this test failure on a PR that was unrelated to `div` and seems like
the test may be non-deterministic i.e. not using a fixed seed but I am not 100%
sure.
```
2025-03-11T22:58:01.9967969Z - Decimal random number tests *** FAILED ***
(30 seconds, 904 milliseconds)
2025-03-11T22:58:01.9969097Z Results do not match for query:
2025-03-11T22:58:01.9977137Z 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]]
2025-03-11T22:58:01.9980015Z Timezone Env:
2025-03-11T22:58:01.9980331Z
2025-03-11T22:58:01.9980616Z == Parsed Logical Plan ==
2025-03-11T22:58:01.9981131Z Project [a#135012, b#135013, (a#135012 div
b#135013) AS (a div b)#135734L]
2025-03-11T22:58:01.9981700Z +- SubqueryAlias spark_catalog.default.test
2025-03-11T22:58:01.9982301Z +- Relation
spark_catalog.default.test[a#135012,b#135013] parquet
2025-03-11T22:58:01.9982819Z
2025-03-11T22:58:01.9983112Z == Analyzed Logical Plan ==
2025-03-11T22:58:01.9983541Z a: decimal(38,0), b: decimal(2,2), (a div b):
bigint
2025-03-11T22:58:01.9984839Z Project [a#135012, b#135013, (a#135012 div
b#135013) AS (a div b)#135734L]
2025-03-11T22:58:01.9985492Z +- SubqueryAlias spark_catalog.default.test
2025-03-11T22:58:01.9986089Z +- Relation
spark_catalog.default.test[a#135012,b#135013] parquet
2025-03-11T22:58:01.9986625Z
2025-03-11T22:58:01.9986920Z == Optimized Logical Plan ==
2025-03-11T22:58:01.9987447Z Project [a#135012, b#135013, (a#135012 div
b#135013) AS (a div b)#135734L]
2025-03-11T22:58:01.9988130Z +- Relation
spark_catalog.default.test[a#135012,b#135013] parquet
2025-03-11T22:58:01.9988643Z
2025-03-11T22:58:01.9988907Z == Physical Plan ==
2025-03-11T22:58:01.9989257Z *(1) CometColumnarToRow
2025-03-11T22:58:01.9990132Z +- CometProject [a#135012, b#135013, (a div
b)#135734L], [a#135012, b#135013, (a#135012 div b#135013) AS (a div b)#135734L]
2025-03-11T22:58:01.9992392Z +- CometScan parquet
spark_catalog.default.test[a#135012,b#135013] Batched: true, DataFilters: [],
Format: CometParquet, Location: InMemoryFileIndex(1
paths)[file:/__w/datafusion-comet/datafusion-comet/spark/spark-warehouse/test],
PartitionFilters: [], PushedFilters: [], ReadSchema:
struct<a:decimal(38,0),b:decimal(2,2)>
2025-03-11T22:58:01.9993933Z
2025-03-11T22:58:01.9994494Z == Results ==
2025-03-11T22:58:01.9994774Z
2025-03-11T22:58:01.9995035Z == Results ==
2025-03-11T22:58:01.9995345Z !== Correct Answer - 10 ==
== Spark Answer - 10 ==
2025-03-11T22:58:01.9995879Z struct<a:decimal(38,0),b:decimal(2,2),(a div
b):bigint> struct<a:decimal(38,0),b:decimal(2,2),(a div b):bigint>
2025-03-11T22:58:01.9996562Z
[-28357995361121806525706862761593208487,0.87,7291161238655874692]
[-28357995361121806525706862761593208487,0.87,7291161238655874692]
2025-03-11T22:58:01.9997287Z
![-62672277069777110394022909049981876593,-0.40,null]
[-62672277069777110394022909049981876593,-0.40,8770993997598117786]
2025-03-11T22:58:01.9997921Z
![-68299431870253176399167726913574455270,-0.22,null]
[-68299431870253176399167726913574455270,-0.22,-1]
2025-03-11T22:58:01.9998580Z
[-76493436389033420298984674631443469720,0.77,2047302896757186509]
[-76493436389033420298984674631443469720,0.77,2047302896757186509]
2025-03-11T22:58:01.9999251Z
![-77532633078952291817347741106477071062,0.36,null]
[-77532633078952291817347741106477071062,0.36,-1]
2025-03-11T22:58:02.0000258Z
![-79918484954351746825313746420585672848,0.44,null]
[-79918484954351746825313746420585672848,0.44,-1]
2025-03-11T22:58:02.0001474Z
[19561074799139924791894966896645366893,0.84,-1511920647582873129]
[19561074799139924791894966896645366893,0.84,-1511920647582873129]
2025-03-11T22:58:02.0002855Z
[22053918435415460642219818022907905627,0.37,6750894698372871109]
[22053918435415460642219818022907905627,0.37,6750894698372871109]
2025-03-11T22:58:02.0004080Z
![54400354300704342908577384819323710194,0.18,null]
[54400354300704342908577384819323710194,0.18,-1]
2025-03-11T22:58:02.0005374Z
![78585488402645143056239590008272527352,-0.51,null]
[78585488402645143056239590008272527352,-0.51,-4252079254050434654]
(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: github-unsubscr...@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
