Raghavender created CALCITE-1000:
------------------------------------
Summary: How to use @ symbol in SQL QUery
Key: CALCITE-1000
URL: https://issues.apache.org/jira/browse/CALCITE-1000
Project: Calcite
Issue Type: Bug
Components: avatica
Affects Versions: 1.4.0-incubating
Environment: java7
Reporter: Raghavender
Assignee: Julian Hyde
Fix For: 1.4.0-incubating
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)
