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