[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16859664#comment-16859664 ]
Danny Chan commented on CALCITE-3005: ------------------------------------- An compile warning of JavaCC throws: {code:java} Warning: Choice conflict involving two expansions at line 6350, column 13 and line 6353, column 13 respectively. A common prefix is: "LEFT" Consider using a lookahead of 2 for earlier expansion. {code} We need to fix this. > Implement string functions: LEFT, RIGHT > --------------------------------------- > > Key: CALCITE-3005 > URL: https://issues.apache.org/jira/browse/CALCITE-3005 > Project: Calcite > Issue Type: New Feature > Reporter: Forward Xu > Assignee: Forward Xu > Priority: Major > Labels: pull-request-available > Fix For: 1.20.0 > > Time Spent: 6h 50m > Remaining Estimate: 0h > > Some string functions including LEFT, RIGHT are not implemented now. It would > be great if these functions can be implemented. > [{{LEFT(_str_}},_{{len}}_)|https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_left] > Returns the leftmost _{{len}}_ characters from the string _{{str}}_, or > {{NULL}} if any argument is {{NULL}}. > [{{RIGHT(_str_}},_{{len}}_)|https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_right] > Returns the rightmost _{{len}}_ characters from the string _{{str}}_, or > {{NULL}} if any argument is {{NULL}}. -- This message was sent by Atlassian JIRA (v7.6.3#76005)