Vineela Gampa created TEIID-2345:
------------------------------------
Summary: source hints are not honoured for nested sqls
Key: TEIID-2345
URL:
https://issues.jboss.org/browse/TEIID-2345
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Hi
I want to use general hints below. I observed i was able to put my sourcehint as below
which yields generalhint information to data_window procedure.
"SELECT /*+ sh:'foo' bar:'leading' */ \r\n"
+ "
chorus_results.* \r\n"
+
"FROM (\r\n"
+ "
EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT
300', ?)\r\n"
+ ")
AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter
long) AS chorus_results LIMIT 0, 20",
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira