JDG translator has disabled capabilities for GT and LT ------------------------------------------------------ Key: TEIID-3625 URL: https://issues.jboss.org/browse/TEIID-3625 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1 Reporter: Filip Elias Assignee: Steven Hawkins Fix For: 8.12 Operations GT and LT are not pushed down to JDG. Indexes are enabled for all columns. Operations GE and LE are pushed down correctly. Example: The first query is pushed down correctly. The second query doesn't push the "greater than" operator to the source. Query: {code}select intkey from smalla where intNum >= 5 order by intkey{code} PROCESSOR PLAN: {code} AccessNode(0) output=[c.intKey AS IntKey] SELECT g_0.intKey FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.intNum >= 5 ORDER BY g_0.intKey {code} Query: {code}select intkey from smalla where intNum > 5 order by intkey{code} Plan: {code} SortNode(0) output=[c.intKey AS IntKey] [SORT] [IntKey] ProjectNode(1) output=[c.intKey AS IntKey] [c.intKey AS IntKey] SelectNode(2) output=[c.intKey] c.intNum > 5 AccessNode(3) output=[c.intNum, c.intKey] SELECT g_0.intNum, g_0.intKey FROM SmallAs.smallARemotecache AS g_0 {code}