phillipleblanc commented on PR #19321: URL: https://github.com/apache/datafusion/pull/19321#issuecomment-3660514420
> The SQL Standard (Foundation, Section 9.5) requires type inference over CASE expressions to unify/coerce over the whole result expressions (the THEN/ELSE). > > It doesn't cover prepared statements/placeholders explicitly, but I think we should at least unify all non-placeholder expressions, instead of the considering only the first one (which makes the result order-dependent). > > WDYT? It makes sense, but I think its fine to use the first type as the hint for the placeholders - as long as it can be coerced into the unified type when the placeholders are assigned. -- 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]
