[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
winifredtang closed CALCITE-2653. --------------------------------- Resolution: Cannot Reproduce > Correct the operator syntax of String Function SUBSTRING in reference.md > ------------------------------------------------------------------------ > > Key: CALCITE-2653 > URL: https://issues.apache.org/jira/browse/CALCITE-2653 > Project: Calcite > Issue Type: Improvement > Components: site > Affects Versions: 1.17.0 > Reporter: winifredtang > Assignee: Julian Hyde > Priority: Minor > > I wonder if we can change the operator syntax of String Function SUBSTRING > from SUBSTRING(string FROM integer) to SUBSTRING(string, integer). Since it > might be a bit of misleading. > Executing a SQL statement like "select substring(name FROM 2) from > sales.depts;" would throw a exception : > "Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered > "select" at line 2, column 1." > The correct SQL statement is "select substring(NAME,2) from sales.depts;". > SUBSTRING(string FROM integer FOR integer) has the same promble. > If necessary, I'd like to modify it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)