[IGNITE-10934] Order fields don't work in ignite field queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.7
• Component/s: sql
• Assignee: Unassigned
• Reporter: Gaurav Rawat
• Created: 14/Jan/19 16:43
• Updated: 14/Feb/19 14:38
• Resolved: 14/Feb/19 14:37

Description

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 : 

 

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)