xudong963 commented on issue #15771:
URL: https://github.com/apache/datafusion/issues/15771#issuecomment-2940459402
```
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,
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
/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
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
