datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

Sqllogictest(parquet.slt) failed in rustc 1.81.0-nightly (cc8da78a0 2024-07-04) using main branch

Open Rachelint opened this issue 6 months ago • 4 comments

Describe the bug

I found test parquet.slt failed in my branch, then I swith to main and run again, and it failed too... But it can success in my another dev machine and ci...

It is really a strange problem...

One point I found may be related is that, the test will get top10 by timestamp, however top10 has the same timestamp. I suspect it may be realted to some unstable sorts?

Running "parquet.slt"
Running "parquet_sorted_statistics.slt"
External error: query result mismatch:
[SQL] SELECT
  count,
  LAG(timestamp, 1) OVER (ORDER BY timestamp),
  arrow_typeof(LAG(timestamp, 1) OVER (ORDER BY timestamp))
FROM timestamp_with_tz
LIMIT 10;
[Diff] (-expected|+actual)
    0 NULL Timestamp(Millisecond, Some("UTC"))
    0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
    0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
-   4 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
    0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
-   0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
+   12 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
+   2 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
    0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
    14 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
-   0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
-   0 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
+   5 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))
+   1 2014-08-27T14:00:00Z Timestamp(Millisecond, Some("UTC"))

To Reproduce

Just run cargo test --test sqllogictests -- parquet

Expected behavior

No response

Additional context

No response

Rachelint avatar Aug 27 '24 01:08 Rachelint