jamesstarr commented on pull request #2271: URL: https://github.com/apache/calcite/pull/2271#issuecomment-730663893
From what I have read, oracles substr has a different behavior then the standard sql substr. Particularly, that is can return null if a 0 or a negative length is passed in, it translates the 0 start index to 1, and if the start index is negative then the start indexes from the end. @julianhyde, are you suggesting simply aliasing substr to substring? Because that will not work due to the above reasons. If you are suggesting using an api that would intercept the arguments at compile time, that would not work due to function arguments, as @vlsi has already stated. Are you suggesting using a different API to implement the above logic, then could you please point me to class, so I can implement it in the correct place. ---------------------------------------------------------------- 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]
