]
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}')