[teiid-issues] [JBoss JIRA] (TEIID-5865) Odata $expand does not work

[Steven Hawkins (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13823610#comment-13823610 ] 

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.open.redhat.com/odata/accounts/customer(10)?$format=JSON&$expand=address_customer_fk
> 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)