]
Steven Hawkins commented on TEIID-5714:
---------------------------------------
On versions without this fix you'll unfortunately have to pursue on of the workarounds
shown.
Can't push cross source function
--------------------------------
Key: TEIID-5714
URL:
https://issues.jboss.org/browse/TEIID-5714
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.2, 12.1.1
With two sources, MODEL1 and MODEL2, with a function on MODEL1:
CREATE FOREIGN FUNCTION "dbo.examplefunc"(col1 string, col2 date, col3 boolean)
returns bigdecimal;
A query of the function against only a table on MODEL2 will fail with "cannot be
pushed to source":
SELECT MODEL1."dbo.examplefunc"(TAB1.STRINGCOL, TAB1.DATE, TRUE) FROM
MODEL2.TABLE1 TAB1