[ 
https://issues.apache.org/jira/browse/CALCITE-1745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dong Li closed CALCITE-1745.
----------------------------
    Resolution: Cannot Reproduce

Sorry that I test it on wrong version. 
The queries passed on latest Calcite 1.12.0. :)

> CONCAT not supports cascading
> -----------------------------
>
>                 Key: CALCITE-1745
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1745
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Dong Li
>            Assignee: Julian Hyde
>
> SQLs:
> select concat('1','1')  -- pass
> select concat('1', concat('1','1') ) -- failed
> Error message:
> Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered "}" 
> at line 1, column 40.
> Was expecting one of:
>     ")" ...
>     "," ...
>     "NOT" ...
>     "IN" ...
>     "BETWEEN" ...
>     "LIKE" ...
>     "SIMILAR" ...
>     "=" ...
>     ">" ...
>     "<" ...
>     "<=" ...
>     ">=" ...
>     "<>" ...
>     "!=" ...
>     "+" ...
>     "-" ...
>     "*" ...
>     "/" ...
>     "||" ...
>     "AND" ...
>     "OR" ...
>     "IS" ...
>     "MEMBER" ...
>     "SUBMULTISET" ...
>     "MULTISET" ...
>     "[" ...
>     "FILTER" ...
>     "OVER" ...
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:21455)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:21278)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.ParenthesizedQueryOrCommaList(SqlParserImpl.java:674)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.JdbcFunctionCall(SqlParserImpl.java:5558)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.AtomicRowExpression(SqlParserImpl.java:3186)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression3(SqlParserImpl.java:3049)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2b(SqlParserImpl.java:2858)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2(SqlParserImpl.java:2883)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression(SqlParserImpl.java:2837)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SelectExpression(SqlParserImpl.java:1481)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SelectItem(SqlParserImpl.java:1455)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SelectList(SqlParserImpl.java:1431)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlSelect(SqlParserImpl.java:883)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQuery(SqlParserImpl.java:585)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQueryOrExpr(SqlParserImpl.java:2822)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.QueryOrExpr(SqlParserImpl.java:2741)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.OrderedQueryOrExpr(SqlParserImpl.java:503)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:814)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:842)
>         at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:185)
>         at 
> org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:131)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to