datafusion
datafusion copied to clipboard
apache
SortQueryFuzzer found a failing case
Describe the bug
Fuzzer failed during an unrelated change - https://github.com/apache/datafusion/actions/runs/15741542523/job/44367876525?pr=16449.
Not sure how long GitHub retains logs, so I'm also adding the actual output:
---- fuzz_cases::sort_query_fuzz::sort_query_fuzzer_runner stdout ----
[SortQueryFuzzer] Round 0, Query 0 (Config 0)
Seeds:
init_seed = 10313160656544581998
query_seed = 9760675044397831413
config_seed = 2456252688354296803
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY time64_ns ASC
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 48.4 KB
Sort in place threshold bytes: 2.3 KB
[SortQueryFuzzer] Round 0, Query 0 (Config 1)
Seeds:
init_seed = 10313160656544581998
query_seed = 9760675044397831413
config_seed = 13112719340419033750
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY time64_ns ASC
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 42.3 KB
Sort in place threshold bytes: 3.7 KB
[SortQueryFuzzer] Round 0, Query 0 (Config 2)
Seeds:
init_seed = 10313160656544581998
query_seed = 9760675044397831413
config_seed = 11553131583763959573
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY time64_ns ASC
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 21.4 KB
Sort in place threshold bytes: 486.0 B
[SortQueryFuzzer] Round 0, Query 0 (Config 3)
Seeds:
init_seed = 10313160656544581998
query_seed = 9760675044397831413
config_seed = 7181[2061](https://github.com/apache/datafusion/actions/runs/15741542523/job/44367876525?pr=16449#step:4:2062)06220866377
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY time64_ns ASC
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 43.8 KB
Sort in place threshold bytes: 3.2 KB
[SortQueryFuzzer] Round 0, Query 0 (Config 4)
Seeds:
init_seed = 10313160656544581998
query_seed = 9760675044397831413
config_seed = 17269272874247070475
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY time64_ns ASC
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 45.0 KB
Sort in place threshold bytes: 2.3 KB
[SortQueryFuzzer] Round 0, Query 1 (Config 0)
Seeds:
init_seed = 10313160656544581998
query_seed = 15004039071976572201
config_seed = 11807432710583113300
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY timestamp_us DESC LIMIT 3
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 25.8 KB
Sort in place threshold bytes: 2.8 KB
[SortQueryFuzzer] Round 0, Query 1 (Config 1)
Seeds:
init_seed = 10313160656544581998
query_seed = 15004039071976572201
config_seed = 759937414670321802
Dataset schema:
[u8_low:UInt8;N, binary:Binary;N, timestamp_us:Timestamp(Microsecond, None);N, time64_ns:Time64(Nanosecond);N, u8:UInt8;N, i32:Int32;N, duration_nanosecond:Duration(Nanosecond);N, utf8_low:Utf8;N, duration_milliseconds:Duration(Millisecond);N]
Query:
SELECT * FROM sort_fuzz_table ORDER BY timestamp_us DESC LIMIT 3
Config:
Dataset size: 286.6 KB
Number of partitions: 3
Batch size: 6
Memory limit: Unbounded
Per partition memory limit: Unbounded
Sort spill reservation bytes: 47.4 KB
Sort in place threshold bytes: 2.5 KB
thread 'fuzz_cases::sort_query_fuzz::sort_query_fuzzer_runner' panicked at datafusion/core/tests/fuzz_cases/sort_query_fuzz.rs:232:71:
called `Result::unwrap()` on an `Err` value: InconsistentResult { row_idx: 0, lhs_row: "+--------+--------------------------------------+--------------+---------------------------------------------------------------------------------------------+-----+-----------+-------------------------+-------------+-------------------------+", rhs_row: "+--------+------------------------------------------------+--------------+---------------------------------------------------------------------------------------------+-----+-------------+--------------------------+-------------+--------------------------+" }
To Reproduce
No response
Expected behavior
No response
Additional context
No response
