[teiid-issues] [JBoss JIRA] (TEIID-5865) Error with pg arrays
Steven Hawkins (Jira)
issues at jboss.org
Fri Dec 13 17:21:00 EST 2019
[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13825549#comment-13825549 ]
Steven Hawkins commented on TEIID-5865:
---------------------------------------
Settled on disabling pg array_agg support and turning off the ability to select array expressions.
> Error with pg arrays
> --------------------
>
> Key: TEIID-5865
> URL: https://issues.redhat.com/browse/TEIID-5865
> Project: Teiid
> Issue Type: Bug
> Components: OData, Query Engine
> Affects Versions: 12.3
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2.2, 12.3.1, 13.1, 13.0.1
>
> Original Estimate: 5 hours
> Time Spent: 5 hours
> Remaining Estimate: 0 minutes
>
> 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 occurs with any pg array that is created with an expression:
> select (col, col2)..
> array_agg, etc.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list