[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1572) Teiid ODBC does not handle SET and Show operations correctly

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy resolved TEIID-1572.
---------------------------------

    Resolution: Done


SET was regression from previous version, but SHOW support is new for the ODBC. Currently SHOW only works for

- DateStyle
- client_encoding
- default_transaction_isolation
- TimeZone
+ any properties that have been explicitly set by SET, or any of the Execution Properties set on Teiid. 

Since most of the PG specific properties are not relevant to Teiid they will not be supported.

PG supports various types of SET command, Teiid only supports

SET prop To value

currently. Any others will be considered as needed basis. 

> Teiid ODBC does not handle SET and Show operations correctly
> ------------------------------------------------------------
>
>                 Key: TEIID-1572
>                 URL: https://issues.jboss.org/browse/TEIID-1572
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 7.2
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 7.4
>
>
> - ODBC protocol expects 'SET' string as command completion when a SET command is issued, this is being ignored
> - PG lets user query the database on configuration using SHOW command. Teiid supports the SHOW command, however since not all properties defined during initialization and some defaults not set explicitly they are not available for the SHOW command. This command being used by Python client. 

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