winifredtang created CALCITE-2653: ------------------------------------- Summary: Correct the description 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
I wonder if we can change the operator syntax of String Function SUBSTRING from SUBSTRING(string FROM integer) to SUBSTRING(string, integet). Since it might be a bit of missleading. 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)