[teiid-issues] [JBoss JIRA] Commented: (TEIID-1631) ODBC SQLDescribeCol does not work, When used with the Prepare Stastement

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12607610#comment-12607610 ] 

Ramesh Reddy commented on TEIID-1631:
-------------------------------------

Looking into the PG Wire protocol, I found 

The Describe message (statement variant) specifies the name of an existing prepared statement (or an empty string for the unnamed prepared statement). The response is a ParameterDescription message describing the parameters needed by the statement, followed by a RowDescription message describing the rows that will be returned when the statement is eventually executed (or a NoData message if the statement will not return rows).

Where in the code Teiid only sending the parameter metadata and not the following row metdata. This is fixed in the attached patch (apply on the runtime module). Please make sure that this patch is applied in all appropriate branches.

> ODBC SQLDescribeCol does not work, When used with the Prepare Stastement
> ------------------------------------------------------------------------
>
>                 Key: TEIID-1631
>                 URL: https://issues.jboss.org/browse/TEIID-1631
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 7.1.1, 7.2, 7.3, 7.4
>            Reporter: Ramesh Reddy
>              Labels: odbc, teiid
>             Fix For: 7.1.1, 7.4.1, 7.5
>
>         Attachments: teiid-runtime.patch
>
>
> When ODBC using the Prepared Statements, the metadata should be readily available after the "prepare" call and before the "execute" call. It has been observed that the metadata is only available after execute.  

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira