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)
