Details
-
Bug
-
Resolution: Incomplete
-
Major
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
The Query is as follows:
SELECT o.o_ol_cnt, COUNT(*) as order_COUNT
|
FROM orders o
|
WHERE o.o_entry_d >= '2015-07-01 00:00:00.000000' AND o.o_entry_d < '2015-10-01 00:00:00.000000'
|
AND EXISTS (SELECT VALUE 1
|
FROM o.orderline ol
|
WHERE ol.ol_delivery_d >= date_add_str(o.o_entry_d, 1, 'week'))
|
GROUP BY o.o_ol_cnt
|
ORDER BY o.o_ol_cnt;
|
The create index command is
create index entrydate on orders (o_entry_d:string);
|
The text plan is attached (indexplan.txt) clearly shows an index search node.
However, the GUI plan seems severely truncated and consists of only 10 boxes. It starts with a PROJECT box!
The screen shot of the index plan is also attached.