[
https://issues.apache.org/jira/browse/IGNITE-10934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov closed IGNITE-10934.
------------------------------------
> Order fields don't work in ignite field queries
> ------------------------------------------------
>
> Key: IGNITE-10934
> URL: https://issues.apache.org/jira/browse/IGNITE-10934
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.7
> Reporter: Gaurav Rawat
> Priority: Major
>
> There is an issue when we use fields woth a field such as order . seems the
> H2 query engine recognizes this is a keyword .
> example query :
> SELECT fund.fund_id, fund.close_dt, fund.idea_id, pm .order FROM "fund".FUND
> fund LEFT JOIN "pm ".PM pm ON fund.FUND_ID = pm .FUND_ID limit 40
>
> error :
>
> {code:java}
> Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement .....
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
> at org.h2.message.DbException.getSyntaxError(DbException.java:217)
> at org.h2.command.Parser.readColumnIdentifier(Parser.java:3507)
> at org.h2.command.Parser.readTermObjectDot(Parser.java:2964)
> at org.h2.command.Parser.readTerm(Parser.java:3095)
> at org.h2.command.Parser.readFactor(Parser.java:2587)
> at org.h2.command.Parser.readSum(Parser.java:2574)
> at org.h2.command.Parser.readConcat(Parser.java:2544)
> at org.h2.command.Parser.readCondition(Parser.java:2370)
> at org.h2.command.Parser.readAnd(Parser.java:2342)
> at org.h2.command.Parser.readExpression(Parser.java:2334)
> at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:2245)
>
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
