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

Reply via email to