You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "winifredtang (JIRA)" <ji...@apache.org> on 2018/11/02 09:33:00 UTC

[jira] [Created] (CALCITE-2653) Correct the description of String Function SUBSTRING in reference.md

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)