[jira] [Updated] (CALCITE-1000) How to use @ symbol in SQL QUery

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde updated CALCITE-1000:
---------------------------------
    Component/s:     (was: avatica)

> How to use @ symbol in SQL QUery
> --------------------------------
>
>                 Key: CALCITE-1000
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1000
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.4.0-incubating
>         Environment: java7
>            Reporter: Raghavender
>            Assignee: Julian Hyde
>
> I am unable to execute sql query when query has @ symbol which generally we use to declare placeholders. I am getting below error.
> query:
> "insert into planning_point_data_cache (ts_business_name_id,planning_point_seq,detail_id,detail_id,period_id,cache_value)" +
> 				" select ppd.ts_business_name_id,denorm.input_ppt_cache_seq,denorm.detail_id,denorm.period_id,sum(ppd.\"VALUE\") " +
> 				"from rule_output_input_map_normalize denorm join planning_point_data ppd on denorm.input_ppt_seq=ppd.planning_point_seq" +
> 				" where denorm.param_order= @PARAM_ID and denorm.input_ppt_cache_seq>0 group by ppd.ts_business_name_id";
> 				
> 				
> Here goes
> org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 377.  Encountered: "@" (64), after : ""
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:388)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:118)
> 	at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:130)
> 	at TestSqlParser.main(TestSqlParser.java:29)
> Caused by: org.apache.calcite.sql.parser.impl.TokenMgrError: Lexical error at line 1, column 377.  Encountered: "@" (64), after : ""
> 	at org.apache.calcite.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:13787)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:16484)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_225(SqlParserImpl.java:10737)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_83(SqlParserImpl.java:10726)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_217(SqlParserImpl.java:10980)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_82(SqlParserImpl.java:11001)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_112(SqlParserImpl.java:11723)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_67(SqlParserImpl.java:11730)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_190(SqlParserImpl.java:12161)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_62(SqlParserImpl.java:12139)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_181(SqlParserImpl.java:12264)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_184(SqlParserImpl.java:12588)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_185(SqlParserImpl.java:12603)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_2_185(SqlParserImpl.java:6514)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2(SqlParserImpl.java:2396)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression(SqlParserImpl.java:2366)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.WhereOpt(SqlParserImpl.java:1867)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlSelect(SqlParserImpl.java:822)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQuery(SqlParserImpl.java:578)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQueryOrExpr(SqlParserImpl.java:2351)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.QueryOrExpr(SqlParserImpl.java:2270)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.OrderedQueryOrExpr(SqlParserImpl.java:496)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1009)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:754)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:776)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:177)
> 	at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:123)
> 	... 1 more
>  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)