dhamotharan-ps commented on issue #8790:
URL:
https://github.com/apache/arrow-datafusion/issues/8790#issuecomment-1889307772
@alamb When I use variadic_equal(), the following tests were failing.
```
failures:
tpcds_logical_q40
tpcds_logical_q49
tpcds_logical_q67
tpcds_logical_q75
tpcds_logical_q77
tpcds_logical_q78
tpcds_logical_q80
tpcds_physical_q40
tpcds_physical_q49
tpcds_physical_q67
tpcds_physical_q75
tpcds_physical_q77
tpcds_physical_q78
tpcds_physical_q80
```
The error messages are:
```
---- tpcds_physical_q78 stdout ----
Error: Plan("No function matches the given name and argument types
'coalesce(Decimal128(17, 2), Int64)'. You might need to add explicit type
casts.\n\tCandidate functions:\n\tcoalesce(CoercibleT, .., CoercibleT)")
---- tpcds_physical_q80 stdout ----
Error: Plan("No function matches the given name and argument types
'coalesce(Decimal128(7, 2), Int64)'. You might need to add explicit type
casts.\n\tCandidate functions:\n\tcoalesce(CoercibleT, .., CoercibleT)")
---- Another error for UInt64
External error: query failed: DataFusion error: Error during planning: No
function matches the given name and argument types 'coalesce(UInt64, Int64)'.
You might need to add explicit type casts.
Candidate functions:
coalesce(CoercibleT, .., CoercibleT)
[SQL] select col1, col2, coalesce(sum_col3, 0) as sum_col3
from (select distinct col2 from tbl) AS q1
cross join (select distinct col1 from tbl) AS q2
left outer join (SELECT col1, col2, sum(col3) as sum_col3 FROM tbl GROUP BY
col1, col2) AS q3
USING(col2, col1)
ORDER BY col1, col2
at test_files/joins.slt:1785
```
The root-cause is coerced_from() is not handling Decimcal128() and UInt64
datatypes.
Before this fix, Decimal types are typecasted to Float64 before coming to
coerced_from() and so they were working.
We would require to improve coerced_from() function to handle more
datatypes. I also try other approaches to fix this issue.
--
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]
