[
https://issues.jboss.org/browse/TEIIDDES-992?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-992:
-----------------------------------------
With the restriction of pushdown only, that could work. There would need to be Designer
validation on a procedure marked as function=true, such as ensuring that it has a return
parameter and only has input parameters. Otherwise the indexing would then be exactly the
same. We would just need to make a few changes on the Teiid side to have the procedures
loaded as schema scoped functions, then everything would work as expected.
The only remaining issue then would be semantic equivalence, but we could punt on that
initially.
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
Reporter: Bernd Groh
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:
http://www.atlassian.com/software/jira