Is Option MAKEDEP inside of Union Supported Now?

[mike_higgins]

In my testing of 9.1, it seems that MAKDEP hints are parsed in a query that is contained in a union, but not applied to the query.

I see that [TEIID-2381] Expanded source hint support - JBoss Issue Tracker discusses the difficulty of applying hints to a branch of a union, but U was not sure if there have been any changes in this area.

Hints applied to the outermost query are applied, but to each instance of the table in the union query.  My problem is that only one of the branches of the union needs a MAKEDEP, not all of them.  Other instances of the same table should be processed normally (hint-less).

Although it would be difficult, I could make sure that each instance of the table that needs a MAKDEP gets a unique alias, and use 'option makedep' on that alias.  When changing the SQL by hand (it's machine generated) this seems to work.

Or, is there a better way?  Or am I just doing something wrong, and the hint should apply to the branch now?

Thanks,

Mike Higgins

PS - as you probably already know, UNION or UNION ALL does not change planning

[shawkins]

[TEIID-2263] makedep makenotdep hints should allow for more complicated scenarios - JBoss Issue Tracker allowed hints to be specific to view layers, but there's nothing yet to make a hint specific to union branch.

> Or, is there a better way?  Or am I just doing something wrong, and the hint should apply to the branch now?

No a unique alias name is probably the best workaround. 

It would take an enhancement on top of TEIID-2263 to support a syntax for specifying union branches as well.