zhuqi-lucas commented on issue #15771:
URL: https://github.com/apache/datafusion/issues/15771#issuecomment-2940544620
> ```
>
> 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
/private/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg/apache-datafusion-48.0.0/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
/private/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg/apache-datafusion-48.0.0/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
/private/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg/apache-datafusion-48.0.0/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,
Flo
at64, 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([UInt
32, 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, Fl
oat64, 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
/private/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg/apache-datafusion-48.0.0/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:
`/private/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg/apache-datafusion-48.0.0/target/debug/deps/sqllogictests-0c67bd38a61466be`
(exit status: 1)
> + cleanup
> + '[' no = yes ']'
> + echo 'Failed to verify release candidate. See
/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg
for details.'
> Failed to verify release candidate. See
/var/folders/kt/7wgx74xx361fymytfdf95slh0000gn/T/datafusion-48.0.0.XXXXX.Iey5QRI4xg
for details.
> ```
>
> I verified locally but got error
Hi @xudong963 :
Because the CI testing will automatically setting the RUST_BACKTRACE=1
We need to pass backtrace env for running new sqllogictest, it can be passed
by locally testing:
RUST_BACKTRACE=1 cargo test --profile ci --features backtrace --test
sqllogictests
--
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
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
