[
https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
winifredtang updated CALCITE-2653:
----------------------------------
Description:
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.
was:
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.
> 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)
