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

   ### Describe the bug
   
   In my test suite I have a test that includes the following:
   
   ` substr(error_code, 3)`
   
   where error_code was an int32. In  previous versions of DF the error_code 
used to be automatically coerced to Utf8 however with 
https://github.com/apache/datafusion/pull/12308 a `coerce_types` impl was added 
that no longer will try to coerce types to Utf8.  Instead the sql needs to be 
changed to the following to work
   
   `substr(error_code::varchar, 3)`
   
   
   
   ### To Reproduce
   
   ```sql
   select substr(123456, 3);
   ```
   
   ### Expected behavior
   
   type coercion should allow for this to work as it used to.
   
   ### 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