[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=13825507#comment-13825507 ] 

Steven Hawkins commented on TEIID-5865:
---------------------------------------

Long story short - any array that we currently construct with pushdown sql using parens is actually a record type and is returned as pg object.  This was done because using the explicit array syntax ARRAY[] only supports elements of the same type.  However even in the one dimensional case the translator still isn't accounting for this.  Since we do support mixed type arrays we need to use records and always correct the result.

> 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
>             Fix For: 13.1
>
>   Original Estimate: 5 hours
>  Remaining Estimate: 5 hours
>
> 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)