[teiid-issues] [JBoss JIRA] (TEIID-1835) Querying a table built from WSDL Importer has no source query?

[Steven Hawkins (Resolved) (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1835.
-----------------------------------

    Resolution: Rejected


There is no source query that should be executed.  You are calling to xmltable to extract results from the input document.  It looks like you are calling the procedure that should be called on your result document with your input document.  

Note that your procedure is defined as:

CREATE VIRTUAL PROCEDURE BEGIN SELECT t.* FROM XMLTABLE( XMLNAMESPACES( DEFAULT '') ,'/SuppInfo_Output/SuppInfo_Output_Instance' PASSING xml_in COLUMNS "SUPPLIER_ID" string,  "SUPPLIER_NAME" string,  "SUPPLIER_STATUS" bigdecimal,  "SUPPLIER_CITY" string,  "SUPPLIER_STATE" string,  "PART_ID" string,  "QUANTITY" bigdecimal,  "SHIPPER_ID" bigdecimal) AS t; END

So it will successfully extract values from something that has the from /SuppInfo_Output/SuppInfo_Output_Instance - which of course does not match the input document.
                
> Querying a table built from WSDL Importer has no source query?
> --------------------------------------------------------------
>
>                 Key: TEIID-1835
>                 URL: https://issues.jboss.org/browse/TEIID-1835
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4.1
>         Environment: SOA-P 5.2 GA
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>         Attachments: QueryPlan_WSDL_to_Rel.txt, WsdlRel_CommandLog.txt, WsdlToRel_MPS.zip
>
>
> I had previously deployed a Web service and figured I'd import the WSDL to make a relational model. The Designer process went well. The create procedure, called by: exec PartsWebXML.getSuppInfo.create_SuppInfo_Input('S106')
> generates a result <SuppInfo_Input xmlns="http://www.metamatrix.com/SuppInfo_Input"><SUPPLIER_ID>S106</SUPPLIER_ID></SuppInfo_Input>
> which goes into my query:
> exec PartsWebXML.getSuppInfo.extract_SuppInfo_output_Instance('<SuppInfo_Input xmlns="http://www.metamatrix.com/SuppInfo_Input"><SUPPLIER_ID>S106</SUPPLIER_ID></SuppInfo_Input>')
> The result set consists of zeros rows (only column headings). The query plan (attached) seems to be lacking a source query. The command log entries (also attached) support that theory, AFAICT.
> I'm also attaching the Model Project Set.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira