alamb opened a new issue, #16250:
URL: https://github.com/apache/datafusion/issues/16250
### Describe the bug
When I run sqllogictests locally on my laptop it fails. It appears to pass
on CI
This is annoying as it makes it harder to evaluate changes locally
### To Reproduce
Run either
```
cargo test --test sqllogictests
```
or
```
cargo test --profile ci --features backtrace --test sqllogictests
```
This fails with an error like this:
```
[SQL] SELECT approx_percentile_cont(0.95, c1) WITHIN GROUP (ORDER BY c3)
FROM aggregate_test_100
at
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt:157
Error: Execution("1 failures")
```
<details><summary>Details</summary>
<p>
```
Completed 130 test files in 4 seconds
External error: 4 errors in file
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt
1. statement is expected to fail with error:
(multiline) DataFusion error: Error during planning: Failed to coerce
arguments to satisfy a call to 'approx_percentile_cont_with_weight' function:
coercion from [Utf8View, Int8, Float64] to the signature OneOf([Exact([Int8,
Int8, Float64]), Exact([Int16, Int16, Float64]), Exact([Int32, Int32,
Float64]), Exact([Int64, Int64, Float64]), Exact([UInt8, UInt8, Float64]),
Exact([UInt16, UInt16, Float64]), Exact([UInt32, UInt32, Float64]),
Exact([UInt64, UInt64, Float64]), Exact([Float32, Float32, Float64]),
Exact([Float64, Float64, Float64])]) failed
but got error:
DataFusion error: Error during planning: Failed to coerce arguments to
satisfy a call to 'approx_percentile_cont_with_weight' function: coercion from
[Utf8View, Int8, Float64] to the signature OneOf([Exact([Int8, Int8, Float64]),
Exact([Int16, Int16, Float64]), Exact([Int32, Int32, Float64]), Exact([Int64,
Int64, Float64]), Exact([UInt8, UInt8, Float64]), Exact([UInt16, UInt16,
Float64]), Exact([UInt32, UInt32, Float64]), Exact([UInt64, UInt64, Float64]),
Exact([Float32, Float32, Float64]), Exact([Float64, Float64, Float64])]) failed
No function matches the given name and argument types
'approx_percentile_cont_with_weight(Utf8View, Int8, Float64)'. You might need
to add explicit type casts.
Candidate functions:
approx_percentile_cont_with_weight(Int8, Int8, Float64)
approx_percentile_cont_with_weight(Int16, Int16, Float64)
approx_percentile_cont_with_weight(Int32, Int32, Float64)
approx_percentile_cont_with_weight(Int64, Int64, Float64)
approx_percentile_cont_with_weight(UInt8, UInt8, Float64)
approx_percentile_cont_with_weight(UInt16, UInt16, Float64)
approx_percentile_cont_with_weight(UInt32, UInt32, Float64)
approx_percentile_cont_with_weight(UInt64, UInt64, Float64)
approx_percentile_cont_with_weight(Float32, Float32, Float64)
approx_percentile_cont_with_weight(Float64, Float64, Float64)
[SQL] SELECT approx_percentile_cont_with_weight(c2, 0.95) WITHIN GROUP
(ORDER BY c1) FROM aggregate_test_100
at
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt:135
2. statement is expected to fail with error:
(multiline) DataFusion error: Error during planning: Failed to coerce
arguments to satisfy a call to 'approx_percentile_cont_with_weight' function:
coercion from [Int16, Utf8View, Float64] to the signature OneOf([Exact([Int8,
Int8, Float64]), Exact([Int16, Int16, Float64]), Exact([Int32, Int32,
Float64]), Exact([Int64, Int64, Float64]), Exact([UInt8, UInt8, Float64]),
Exact([UInt16, UInt16, Float64]), Exact([UInt32, UInt32, Float64]),
Exact([UInt64, UInt64, Float64]), Exact([Float32, Float32, Float64]),
Exact([Float64, Float64, Float64])]) failed
but got error:
DataFusion error: Error during planning: Failed to coerce arguments to
satisfy a call to 'approx_percentile_cont_with_weight' function: coercion from
[Int16, Utf8View, Float64] to the signature OneOf([Exact([Int8, Int8,
Float64]), Exact([Int16, Int16, Float64]), Exact([Int32, Int32, Float64]),
Exact([Int64, Int64, Float64]), Exact([UInt8, UInt8, Float64]), Exact([UInt16,
UInt16, Float64]), Exact([UInt32, UInt32, Float64]), Exact([UInt64, UInt64,
Float64]), Exact([Float32, Float32, Float64]), Exact([Float64, Float64,
Float64])]) failed No function matches the given name and argument types
'approx_percentile_cont_with_weight(Int16, Utf8View, Float64)'. You might need
to add explicit type casts.
Candidate functions:
approx_percentile_cont_with_weight(Int8, Int8, Float64)
approx_percentile_cont_with_weight(Int16, Int16, Float64)
approx_percentile_cont_with_weight(Int32, Int32, Float64)
approx_percentile_cont_with_weight(Int64, Int64, Float64)
approx_percentile_cont_with_weight(UInt8, UInt8, Float64)
approx_percentile_cont_with_weight(UInt16, UInt16, Float64)
approx_percentile_cont_with_weight(UInt32, UInt32, Float64)
approx_percentile_cont_with_weight(UInt64, UInt64, Float64)
approx_percentile_cont_with_weight(Float32, Float32, Float64)
approx_percentile_cont_with_weight(Float64, Float64, Float64)
[SQL] SELECT approx_percentile_cont_with_weight(c1, 0.95) WITHIN GROUP
(ORDER BY c3) FROM aggregate_test_100
at
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt:141
3. statement is expected to fail with error:
(multiline) DataFusion error: Error during planning: Failed to coerce
arguments to satisfy a call to 'approx_percentile_cont_with_weight' function:
coercion from [Int16, Int8, Utf8View] to the signature OneOf([Exact([Int8,
Int8, Float64]), Exact([Int16, Int16, Float64]), Exact([Int32, Int32,
Float64]), Exact([Int64, Int64, Float64]), Exact([UInt8, UInt8, Float64]),
Exact([UInt16, UInt16, Float64]), Exact([UInt32, UInt32, Float64]),
Exact([UInt64, UInt64, Float64]), Exact([Float32, Float32, Float64]),
Exact([Float64, Float64, Float64])]) failed
but got error:
DataFusion error: Error during planning: Failed to coerce arguments to
satisfy a call to 'approx_percentile_cont_with_weight' function: coercion from
[Int16, Int8, Utf8View] to the signature OneOf([Exact([Int8, Int8, Float64]),
Exact([Int16, Int16, Float64]), Exact([Int32, Int32, Float64]), Exact([Int64,
Int64, Float64]), Exact([UInt8, UInt8, Float64]), Exact([UInt16, UInt16,
Float64]), Exact([UInt32, UInt32, Float64]), Exact([UInt64, UInt64, Float64]),
Exact([Float32, Float32, Float64]), Exact([Float64, Float64, Float64])]) failed
No function matches the given name and argument types
'approx_percentile_cont_with_weight(Int16, Int8, Utf8View)'. You might need to
add explicit type casts.
Candidate functions:
approx_percentile_cont_with_weight(Int8, Int8, Float64)
approx_percentile_cont_with_weight(Int16, Int16, Float64)
approx_percentile_cont_with_weight(Int32, Int32, Float64)
approx_percentile_cont_with_weight(Int64, Int64, Float64)
approx_percentile_cont_with_weight(UInt8, UInt8, Float64)
approx_percentile_cont_with_weight(UInt16, UInt16, Float64)
approx_percentile_cont_with_weight(UInt32, UInt32, Float64)
approx_percentile_cont_with_weight(UInt64, UInt64, Float64)
approx_percentile_cont_with_weight(Float32, Float32, Float64)
approx_percentile_cont_with_weight(Float64, Float64, Float64)
[SQL] SELECT approx_percentile_cont_with_weight(c2, c1) WITHIN GROUP (ORDER
BY c3) FROM aggregate_test_100
at
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt:147
4. statement is expected to fail with error:
(multiline) DataFusion error: Error during planning: Failed to coerce
arguments to satisfy a call to 'approx_percentile_cont' function: coercion from
[Int16, Float64, Utf8View] to the signature OneOf([Exact([Int8, Float64]),
Exact([Int8, Float64, Int8]), Exact([Int8, Float64, Int16]), Exact([Int8,
Float64, Int32]), Exact([Int8, Float64, Int64]), Exact([Int8, Float64, UInt8]),
Exact([Int8, Float64, UInt16]), Exact([Int8, Float64, UInt32]), Exact([Int8,
Float64, UInt64]), Exact([Int16, Float64]), Exact([Int16, Float64, Int8]),
Exact([Int16, Float64, Int16]), Exact([Int16, Float64, Int32]), Exact([Int16,
Float64, Int64]), Exact([Int16, Float64, UInt8]), Exact([Int16, Float64,
UInt16]), Exact([Int16, Float64, UInt32]), Exact([Int16, Float64, UInt64]),
Exact([Int32, Float64]), Exact([Int32, Float64, Int8]), Exact([Int32, Float64,
Int16]), Exact([Int32, Float64, Int32]), Exact([Int32, Float64, Int64]),
Exact([Int32, Float64, UInt8]), Exact([Int32, Float64, UInt16]), Exact([Int32,
Float
64, UInt32]), Exact([Int32, Float64, UInt64]), Exact([Int64, Float64]),
Exact([Int64, Float64, Int8]), Exact([Int64, Float64, Int16]), Exact([Int64,
Float64, Int32]), Exact([Int64, Float64, Int64]), Exact([Int64, Float64,
UInt8]), Exact([Int64, Float64, UInt16]), Exact([Int64, Float64, UInt32]),
Exact([Int64, Float64, UInt64]), Exact([UInt8, Float64]), Exact([UInt8,
Float64, Int8]), Exact([UInt8, Float64, Int16]), Exact([UInt8, Float64,
Int32]), Exact([UInt8, Float64, Int64]), Exact([UInt8, Float64, UInt8]),
Exact([UInt8, Float64, UInt16]), Exact([UInt8, Float64, UInt32]), Exact([UInt8,
Float64, UInt64]), Exact([UInt16, Float64]), Exact([UInt16, Float64, Int8]),
Exact([UInt16, Float64, Int16]), Exact([UInt16, Float64, Int32]),
Exact([UInt16, Float64, Int64]), Exact([UInt16, Float64, UInt8]),
Exact([UInt16, Float64, UInt16]), Exact([UInt16, Float64, UInt32]),
Exact([UInt16, Float64, UInt64]), Exact([UInt32, Float64]), Exact([UInt32,
Float64, Int8]), Exact([UInt32, Float64, Int16]), E
xact([UInt32, Float64, Int32]), Exact([UInt32, Float64, Int64]),
Exact([UInt32, Float64, UInt8]), Exact([UInt32, Float64, UInt16]),
Exact([UInt32, Float64, UInt32]), Exact([UInt32, Float64, UInt64]),
Exact([UInt64, Float64]), Exact([UInt64, Float64, Int8]), Exact([UInt64,
Float64, Int16]), Exact([UInt64, Float64, Int32]), Exact([UInt64, Float64,
Int64]), Exact([UInt64, Float64, UInt8]), Exact([UInt64, Float64, UInt16]),
Exact([UInt64, Float64, UInt32]), Exact([UInt64, Float64, UInt64]),
Exact([Float32, Float64]), Exact([Float32, Float64, Int8]), Exact([Float32,
Float64, Int16]), Exact([Float32, Float64, Int32]), Exact([Float32, Float64,
Int64]), Exact([Float32, Float64, UInt8]), Exact([Float32, Float64, UInt16]),
Exact([Float32, Float64, UInt32]), Exact([Float32, Float64, UInt64]),
Exact([Float64, Float64]), Exact([Float64, Float64, Int8]), Exact([Float64,
Float64, Int16]), Exact([Float64, Float64, Int32]), Exact([Float64, Float64,
Int64]), Exact([Float64, Float64, UInt8]), Exact([F
loat64, Float64, UInt16]), Exact([Float64, Float64, UInt32]), Exact([Float64,
Float64, UInt64])]) failed
but got error:
DataFusion error: Error during planning: Failed to coerce arguments to
satisfy a call to 'approx_percentile_cont' function: coercion from [Int16,
Float64, Utf8View] to the signature OneOf([Exact([Int8, Float64]), Exact([Int8,
Float64, Int8]), Exact([Int8, Float64, Int16]), Exact([Int8, Float64, Int32]),
Exact([Int8, Float64, Int64]), Exact([Int8, Float64, UInt8]), Exact([Int8,
Float64, UInt16]), Exact([Int8, Float64, UInt32]), Exact([Int8, Float64,
UInt64]), Exact([Int16, Float64]), Exact([Int16, Float64, Int8]), Exact([Int16,
Float64, Int16]), Exact([Int16, Float64, Int32]), Exact([Int16, Float64,
Int64]), Exact([Int16, Float64, UInt8]), Exact([Int16, Float64, UInt16]),
Exact([Int16, Float64, UInt32]), Exact([Int16, Float64, UInt64]), Exact([Int32,
Float64]), Exact([Int32, Float64, Int8]), Exact([Int32, Float64, Int16]),
Exact([Int32, Float64, Int32]), Exact([Int32, Float64, Int64]), Exact([Int32,
Float64, UInt8]), Exact([Int32, Float64, UInt16]), Exact([Int32, Float64,
UInt32])
, Exact([Int32, Float64, UInt64]), Exact([Int64, Float64]), Exact([Int64,
Float64, Int8]), Exact([Int64, Float64, Int16]), Exact([Int64, Float64,
Int32]), Exact([Int64, Float64, Int64]), Exact([Int64, Float64, UInt8]),
Exact([Int64, Float64, UInt16]), Exact([Int64, Float64, UInt32]), Exact([Int64,
Float64, UInt64]), Exact([UInt8, Float64]), Exact([UInt8, Float64, Int8]),
Exact([UInt8, Float64, Int16]), Exact([UInt8, Float64, Int32]), Exact([UInt8,
Float64, Int64]), Exact([UInt8, Float64, UInt8]), Exact([UInt8, Float64,
UInt16]), Exact([UInt8, Float64, UInt32]), Exact([UInt8, Float64, UInt64]),
Exact([UInt16, Float64]), Exact([UInt16, Float64, Int8]), Exact([UInt16,
Float64, Int16]), Exact([UInt16, Float64, Int32]), Exact([UInt16, Float64,
Int64]), Exact([UInt16, Float64, UInt8]), Exact([UInt16, Float64, UInt16]),
Exact([UInt16, Float64, UInt32]), Exact([UInt16, Float64, UInt64]),
Exact([UInt32, Float64]), Exact([UInt32, Float64, Int8]), Exact([UInt32,
Float64, Int16]), Exact([UInt32
, Float64, Int32]), Exact([UInt32, Float64, Int64]), Exact([UInt32, Float64,
UInt8]), Exact([UInt32, Float64, UInt16]), Exact([UInt32, Float64, UInt32]),
Exact([UInt32, Float64, UInt64]), Exact([UInt64, Float64]), Exact([UInt64,
Float64, Int8]), Exact([UInt64, Float64, Int16]), Exact([UInt64, Float64,
Int32]), Exact([UInt64, Float64, Int64]), Exact([UInt64, Float64, UInt8]),
Exact([UInt64, Float64, UInt16]), Exact([UInt64, Float64, UInt32]),
Exact([UInt64, Float64, UInt64]), Exact([Float32, Float64]), Exact([Float32,
Float64, Int8]), Exact([Float32, Float64, Int16]), Exact([Float32, Float64,
Int32]), Exact([Float32, Float64, Int64]), Exact([Float32, Float64, UInt8]),
Exact([Float32, Float64, UInt16]), Exact([Float32, Float64, UInt32]),
Exact([Float32, Float64, UInt64]), Exact([Float64, Float64]), Exact([Float64,
Float64, Int8]), Exact([Float64, Float64, Int16]), Exact([Float64, Float64,
Int32]), Exact([Float64, Float64, Int64]), Exact([Float64, Float64, UInt8]),
Exact([Float64, Floa
t64, UInt16]), Exact([Float64, Float64, UInt32]), Exact([Float64, Float64,
UInt64])]) failed No function matches the given name and argument types
'approx_percentile_cont(Int16, Float64, Utf8View)'. You might need to add
explicit type casts.
Candidate functions:
approx_percentile_cont(Int8, Float64)
approx_percentile_cont(Int8, Float64, Int8)
approx_percentile_cont(Int8, Float64, Int16)
approx_percentile_cont(Int8, Float64, Int32)
approx_percentile_cont(Int8, Float64, Int64)
approx_percentile_cont(Int8, Float64, UInt8)
approx_percentile_cont(Int8, Float64, UInt16)
approx_percentile_cont(Int8, Float64, UInt32)
approx_percentile_cont(Int8, Float64, UInt64)
approx_percentile_cont(Int16, Float64)
approx_percentile_cont(Int16, Float64, Int8)
approx_percentile_cont(Int16, Float64, Int16)
approx_percentile_cont(Int16, Float64, Int32)
approx_percentile_cont(Int16, Float64, Int64)
approx_percentile_cont(Int16, Float64, UInt8)
approx_percentile_cont(Int16, Float64, UInt16)
approx_percentile_cont(Int16, Float64, UInt32)
approx_percentile_cont(Int16, Float64, UInt64)
approx_percentile_cont(Int32, Float64)
approx_percentile_cont(Int32, Float64, Int8)
approx_percentile_cont(Int32, Float64, Int16)
approx_percentile_cont(Int32, Float64, Int32)
approx_percentile_cont(Int32, Float64, Int64)
approx_percentile_cont(Int32, Float64, UInt8)
approx_percentile_cont(Int32, Float64, UInt16)
approx_percentile_cont(Int32, Float64, UInt32)
approx_percentile_cont(Int32, Float64, UInt64)
approx_percentile_cont(Int64, Float64)
approx_percentile_cont(Int64, Float64, Int8)
approx_percentile_cont(Int64, Float64, Int16)
approx_percentile_cont(Int64, Float64, Int32)
approx_percentile_cont(Int64, Float64, Int64)
approx_percentile_cont(Int64, Float64, UInt8)
approx_percentile_cont(Int64, Float64, UInt16)
approx_percentile_cont(Int64, Float64, UInt32)
approx_percentile_cont(Int64, Float64, UInt64)
approx_percentile_cont(UInt8, Float64)
approx_percentile_cont(UInt8, Float64, Int8)
approx_percentile_cont(UInt8, Float64, Int16)
approx_percentile_cont(UInt8, Float64, Int32)
approx_percentile_cont(UInt8, Float64, Int64)
approx_percentile_cont(UInt8, Float64, UInt8)
approx_percentile_cont(UInt8, Float64, UInt16)
approx_percentile_cont(UInt8, Float64, UInt32)
approx_percentile_cont(UInt8, Float64, UInt64)
approx_percentile_cont(UInt16, Float64)
approx_percentile_cont(UInt16, Float64, Int8)
approx_percentile_cont(UInt16, Float64, Int16)
approx_percentile_cont(UInt16, Float64, Int32)
approx_percentile_cont(UInt16, Float64, Int64)
approx_percentile_cont(UInt16, Float64, UInt8)
approx_percentile_cont(UInt16, Float64, UInt16)
approx_percentile_cont(UInt16, Float64, UInt32)
approx_percentile_cont(UInt16, Float64, UInt64)
approx_percentile_cont(UInt32, Float64)
approx_percentile_cont(UInt32, Float64, Int8)
approx_percentile_cont(UInt32, Float64, Int16)
approx_percentile_cont(UInt32, Float64, Int32)
approx_percentile_cont(UInt32, Float64, Int64)
approx_percentile_cont(UInt32, Float64, UInt8)
approx_percentile_cont(UInt32, Float64, UInt16)
approx_percentile_cont(UInt32, Float64, UInt32)
approx_percentile_cont(UInt32, Float64, UInt64)
approx_percentile_cont(UInt64, Float64)
approx_percentile_cont(UInt64, Float64, Int8)
approx_percentile_cont(UInt64, Float64, Int16)
approx_percentile_cont(UInt64, Float64, Int32)
approx_percentile_cont(UInt64, Float64, Int64)
approx_percentile_cont(UInt64, Float64, UInt8)
approx_percentile_cont(UInt64, Float64, UInt16)
approx_percentile_cont(UInt64, Float64, UInt32)
approx_percentile_cont(UInt64, Float64, UInt64)
approx_percentile_cont(Float32, Float64)
approx_percentile_cont(Float32, Float64, Int8)
approx_percentile_cont(Float32, Float64, Int16)
approx_percentile_cont(Float32, Float64, Int32)
approx_percentile_cont(Float32, Float64, Int64)
approx_percentile_cont(Float32, Float64, UInt8)
approx_percentile_cont(Float32, Float64, UInt16)
approx_percentile_cont(Float32, Float64, UInt32)
approx_percentile_cont(Float32, Float64, UInt64)
approx_percentile_cont(Float64, Float64)
approx_percentile_cont(Float64, Float64, Int8)
approx_percentile_cont(Float64, Float64, Int16)
approx_percentile_cont(Float64, Float64, Int32)
approx_percentile_cont(Float64, Float64, Int64)
approx_percentile_cont(Float64, Float64, UInt8)
approx_percentile_cont(Float64, Float64, UInt16)
approx_percentile_cont(Float64, Float64, UInt32)
approx_percentile_cont(Float64, Float64, UInt64)
[SQL] SELECT approx_percentile_cont(0.95, c1) WITHIN GROUP (ORDER BY c3)
FROM aggregate_test_100
at
/Users/andrewlamb/Software/datafusion/datafusion/sqllogictest/test_files/aggregate.slt:157
Error: Execution("1 failures")
error: test failed, to rerun pass `-p datafusion-sqllogictest --test
sqllogictests`
Caused by:
process didn't exit successfully:
`/Users/andrewlamb/Software/datafusion/target/debug/deps/sqllogictests-091887b103c8724d`
(exit status: 1)
```
</p>
</details>
### 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
