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

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

The issue is that the SQL array returned by pg contains PGObject instances - not arrays.  So there either needs to be additional translator logic to handle multi-dimensional array results, or array_agg at least for array values would need to be disabled.  Since we don't currently have the type specific checks on aggregate functions I'll first see if the translator can handle converting the PGObject values to arrays.

> 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)