Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.18.1
-
None
-
None
Description
The table options hints don't work well with multiple WITH clauses referring to the same table. Please see the following example.
The following query with hints works well.
SELECT * FROM T1 /*+ OPTIONS('foo' = 'bar') */ WHERE...;
The following query with multiple WITH clauses also works well.
WITH T2 AS (SELECT * FROM T1 /*+ OPTIONS('foo' = 'bar') */ WHERE...),
T3 AS (SELECT ... FROM T2 WHERE...)
SELECT * FROM T3;
The following query with multiple WITH clauses referring to the same original table failed to recognize the hints.
WITH T2 AS (SELECT * FROM T1 /*+ OPTIONS('foo' = 'bar') */ WHERE...),
T3 AS (SELECT ... FROM T2 WHERE...),
T4 AS (SELECT ... FROM T2 WHERE...),
T5 AS (SELECT ... FROM T3 JOIN T4 ON...)
SELECT * FROM T5;