[
https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2664:
----------------------------------------
[~shawkins] Is this defined in your current BNF?
(
https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...)
If it's a change to your BNF, then the Teiid DDL parser needs to be upgraded in
Modeshape to account for the new grammar, else the Parsing for that statement will
probably fail. You can test it easily enough in Designer using the DDL Importer with
Teiid dialect option.
Guess this also mean that you are adding extension properties, but since the
"RETURNS" can be a raw type value OR a TABLE, it would mean adding them as
extension props to the RESULT SET AND an "RESULT" parameter? This is because
our EMF relational metamodel doesn't map directly to your DDL for procedures.
Add OPTIONS capability to Procedure ResultSet
---------------------------------------------
Key: TEIIDDES-2664
URL:
https://issues.jboss.org/browse/TEIIDDES-2664
Project: Teiid Designer
Issue Type: Enhancement
Components: Teiid Integration
Reporter: Ramesh Reddy
Teiid DDL now supports options for procedure/functions returns clause parameters:
... RETURNS (options ...) type
... RETURNS (options ...) TABLE (...)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)