Skip to content

sqllogictest tests fail when run locally #16250

New issue
New issue
Closed
#16251
Closed
sqllogictest tests fail when run locally#16250
#16251
Assignees
alamb
Labels
bugSomething isn't working
@alamb

Description

@alamb
alamb
opened on Jun 4, 2025

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 

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, 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, 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, Float64, 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)

Expected behavior

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions