[JBoss JIRA] (TEIIDDES-2783) Need to add support for parsing OPTIONS in procedure statements
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2783?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2783:
-----------------------------------
Description:
The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause.
CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...
Should be able to parse the following and set the EMF *Description* (Annotation) value when imported into Designer
{code}
CREATE FOREIGN PROCEDURE ProcedureWithRS (
newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'),
newParameter_2 string(4000)
) RETURNS string(255) OPTIONS(ANNOTATION 'Example')
{code}
was:
The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause.
CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...
> Need to add support for parsing OPTIONS in procedure statements
> ---------------------------------------------------------------
>
> Key: TEIIDDES-2783
> URL: https://issues.jboss.org/browse/TEIIDDES-2783
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, ModeShape Integration, Patch Release
> Reporter: Barry LaFond
> Assignee: Dan Florian
> Fix For: 10.0.1
>
>
> The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause.
> CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...
> Should be able to parse the following and set the EMF *Description* (Annotation) value when imported into Designer
> {code}
> CREATE FOREIGN PROCEDURE ProcedureWithRS (
> newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'),
> newParameter_2 string(4000)
> ) RETURNS string(255) OPTIONS(ANNOTATION 'Example')
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2765?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2765.
------------------------------------
Resolution: Out of Date
Reverted initial fix for TEIIDDES-2748 and namespaces for response documents are added correctly.
> View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2765
> URL: https://issues.jboss.org/browse/TEIIDDES-2765
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Fix For: 10.0.1
>
> Attachments: Screen Shot 2016-01-21 at 10.16.55.png
>
>
> Transformation SQL on xxx_response procedures looks like this:
> {code:java}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT t.* FROM
> XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
> COLUMNS
> continentCode string PATH '/continentCode',
> capitalCity string PATH '/capitalCity',
> currencyIsoCode string PATH '/currencyIsoCode',
> isoCode string PATH '/isoCode',
> name string PATH '/name',
> phoneCode string PATH '/phoneCode') AS t;
> END
> {code}
> XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works. (I copied this from TD 9.0.4)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months