[teiid-issues] [JBoss JIRA] (TEIID-5865) Odata $expand does not work
[
https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugi...
]
Steven Hawkins commented on TEIID-5865:
---------------------------------------
This affects sources that support array_agg - the resulting array value is not being
converted to a value that the engine can handle. This seems to be particular to
multi-dimensional arrays - which are created in this case by a pushdown query like SELECT
ARRAY_AGG((col, col..) ...
The engine logic works only seems to work if a raw two dimensional array is given to it.
This will affect the translators that are marked as supporting array_agg and the array
type, so pg, teiid, and couchbase.
A workaround is to disable array_agg support on the translator.
Odata $expand does not work
---------------------------
Key: TEIID-5865
URL: https://issues.redhat.com/browse/TEIID-5865
Project: Teiid
Issue Type: Bug
Components: OData
Affects Versions: 12.3
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
When I try the following query using customer-dv deployment against postgresql
https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope...
I get the following error:
{"error":{"code":"TEIID30504","message":"TEIID30504
sampledb: TEIID31176 Could not convert source column v_0.c_1 AS c_3 to the expected
runtime type object[][]"}}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)