phillipleblanc opened a new issue, #19320:
URL: https://github.com/apache/datafusion/issues/19320

   ### Is your feature request related to a problem or challenge?
   
   Placeholder inference should work for CASE expressions, i.e.
   
   ```sql
   -- Simple CASE with placeholders
   SELECT CASE department_id WHEN $1 THEN 'Match' ELSE 'No match' END FROM 
employees;
   
   -- Searched CASE with placeholders  
   SELECT CASE WHEN salary > $1 THEN $2 ELSE $3 END FROM employees;
   
   -- CASE with placeholder as base expression
   SELECT CASE $1 WHEN 'Engineering' THEN 'Eng' ELSE 'Other' END;
   ```
   
   ### Describe the solution you'd like
   
   `Expr::infer_placeholder_types` should infer the data types of placeholders 
for CASE expressions.
   
   ### Describe alternatives you've considered
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
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]

Reply via email to