[teiid-issues] [JBoss JIRA] (TEIID-5528) Implement insert handling of arrays in PostgreSQL

[Steven Hawkins (Jira)]

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

Steven Hawkins resolved TEIID-5528.
-----------------------------------
    Fix Version/s: 12.0
       Resolution: Done


Updated the pg logic to check for array literals and use a prepared statement binding for them instead.  This will work for simple arrays with known type handling.  

In some corner cases where the array values where not already marked as bindable we may need to reinstate the row value version of the logic for use in comparisons as directly having the literal values would be better for optimization.

> Implement insert handling of arrays in PostgreSQL
> -------------------------------------------------
>
>                 Key: TEIID-5528
>                 URL: https://issues.jboss.org/browse/TEIID-5528
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 11.2
>            Reporter: Vojtech Kolacek
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.0
>
>
> Insert handling of arrays is missing for PostgreSQL, e.g.
> INSERT INTO "public"."form_formname" ("booltest") VALUES ((true, false, true, false))
> is not being translated to
> INSERT INTO "public"."form_formname" ("booltest") VALUES ('{true, false, true, false}')



--
This message was sent by Atlassian Jira
(v7.12.1#712002)