]
Barry LaFond updated TEIIDDES-992:
----------------------------------
Release Notes Text:
What is a 'pushdown' function?
For standard Teiid Designer user-defined functions, the function "code" is
deployed under Teiid, so the function get's executed during the Teiid Query result-set
processing.The "pushdown function" relates to "pushing down" the SQL
that contains the function call as part of the final query all the way to the actual
source or database.
In Designer, we exposed it as creating a "Source Function" which better
describes it as a function that exists or is know by a database source.
Allow the use of pushdown functions without requiring Java
programming
----------------------------------------------------------------------
Key: TEIIDDES-992
URL:
https://issues.jboss.org/browse/TEIIDDES-992
Project: Teiid Designer
Issue Type: Feature Request
Affects Versions: 7.4
Reporter: Bernd Groh
Assignee: Barry LaFond
Fix For: 7.5, 7.4.2
Attachments: CreatePushdownFunctionDialog_draft.png, ProductsSQL.xmi,
PushdownFunction.gif, PushdownFunction.gif, PushdownVDB.vdb,
TEIIDDES-992_pushdownfunctions.patch
Currently, in order to use a database function, even if pushdown is required, it is still
necessary to add the function interface to a Java class within the connector, and the
connector then must be deployed to the server in order to allow for this pushdown function
to be used within the Designer. This creates a lot of extra effort every time you want to
make use of a new database function. Particularly, given the schema designer doesn't
necessarily have access to either the connector code or the server, and then must involve
other parties simply to be able to use an additional database function. It would be very
beneficial to speedy schema development if that was not necessary, and if, say, the
interface could be defined on the Designer side, added to the VDB, and then deployed as
part of the VDB.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: