Details
-
Bug
-
Resolution: Done
-
Major
-
8.7.1
-
None
Description
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:
select intkey from smalla where intNum >= 5 order by intkey
PROCESSOR PLAN:
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
Query:
select intkey from smalla where intNum > 5 order by intkey
Plan:
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
Attachments
Issue Links
- relates to
-
-
- Closed
-
