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)