[teiid-issues] [JBoss JIRA] (TEIID-2491) ODBC ScriptReader workarounds do not handle EOF

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2491.
-----------------------------------

    Resolution: Done


Corrected the appends that do not check for EOF.  This was prompted by a case that uses ODBC escapes, which are being handled by the pg odbc driver using legacy pgsql syntax.  We may yet want to go more completely over the driver source (convert.c) and ensure as much of the escape handling is handled by us directly (including possibly moving the cast support into our parser) - or by perhaps contributing an option to the pg driver to disable escape handling.
                
> ODBC ScriptReader workarounds do not handle EOF
> -----------------------------------------------
>
>                 Key: TEIID-2491
>                 URL: https://issues.jboss.org/browse/TEIID-2491
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 8.3
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.4
>
>
> Issuing a query such as select 'foo'::bar
> will result in an error since the workaround to drop the ::bar appends the EOF to the sql text.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira