This content has been marked as final.
Show 1 reply
-
1. Re: Teiid doesn't recognize custom function in MySQL
shawkins Mar 27, 2018 2:50 PM (in response to ichanjasper)> Do you guys have any idea?
The JDBC import process currently doesn't import information on functions - driver support with DatabaseMetaData.getFunctions started with Java 6 / JDBC 4 and it's still not broadly supported.
You'll have to make Teiid aware of the source function by adding it to the metadata. Using ddl it would be a create statement associated with the schema/model "create foreign function device_type_tb ..."
You can also propose an enhancement based upon DatabaseMetaData or whatever metadata facility mysql supports for defining functions.