adsharma commented on issue #935:
URL: 
https://github.com/apache/arrow-datafusion/issues/935#issuecomment-905826481


   Thanks! That was one problem. Fixed now. 
   
   But there is a second significant problem:
   
   ```
   > SELECT TRIM(BOTH 'leadtrail' FROM 'leadtrailtextleadtrail');
   +---------------------------------------------------------+
   | btrim(Utf8("leadtrailtextleadtrail"),Utf8("leadtrail")) |
   +---------------------------------------------------------+
   | x                                                       |
   +---------------------------------------------------------+
   1 row in set. Query took 0.008 seconds.
   ```
   
   MySQL would output "text".
   
   The problem boils down to the interpretation: is it a set of characters or a 
string to be trimmed?
   
   Perhaps address this in a new PR?


-- 
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: github-unsubscr...@arrow.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Reply via email to