[teiid-issues] [JBoss JIRA] (TEIID-2332) Better handling for pg transport rewrite

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2332.
-----------------------------------

    Resolution: Done


adjusted the ScriptReader logic to handle pg :: casts and added handling for ~/~~ operators, and base support for the pg_description table.

The ScriptReader is a better spot to handle rewrites since it is a very rough parser and aware of whether it's in a literal or other construct.

The refines the fix from TEIID-2096, which while an improvement from the old regex, was still capable of inappropriately modifying the sql.
                
> Better handling for pg transport rewrite
> ----------------------------------------
>
>                 Key: TEIID-2332
>                 URL: https://issues.jboss.org/browse/TEIID-2332
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: ODBC
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.3
>
>
> The regexes used for handling several pg constructs are not generally safe and need to be aware of sql structure.

--
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