vlsi commented on pull request #2271: URL: https://github.com/apache/calcite/pull/2271#issuecomment-730653973
> I.e. treat Oracle's function as syntactic sugar That would not work if downstream Oracle DB has a functional-based index with `SUBSTRING`. If Calcite transforms `SUBSTRING` into `SUBSTR`, then the query won't use the index. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
