[jira] [Created] (IGNITE-10934) Order fields don't work in ignite field queries

["Gaurav Rawat (JIRA)" <ji...@apache.org>]

Gaurav Rawat created IGNITE-10934:
-------------------------------------

             Summary: 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


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)