Loading...

XML

Word

Printable

If you run ANALYZE DATASET on the datasets in the test-suite array-index/composite-index-queries, the 9th query in the suite:

FROM      Dataset2 D2,

          Dataset1 D1

WHERE     D1.field1 /* +indexnl */ = TO_BIGINT(D2.field1) AND

          ( SOME D1I IN D1.items

            SATISFIES D1I.field2 /* +indexnl */ = TO_BIGINT(D2.field2) AND

                      D1I.field3 /* +indexnl */ = TO_BIGINT(D2.field3) ) AND

          D1.field4 /* +indexnl */ = TO_BIGINT(D2.field4)

SELECT    D2.field1, D2.field2, D2.field3, D2.field4

ORDER BY  D2.field1, D2.field2, D2.field3, D2.field4;

Will fail to compile with the following message:

ASX1079: Compilation error: Could not infer type for variable '$$85'.

links to

*DB issue

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

There are no open Gerrit changes

[CX] Query w/ Composite array index fails to compile with CBO