[teiid-issues] [JBoss JIRA] (TEIID-5865) Error with pg arrays
Steven Hawkins (Jira)
issues at jboss.org
Fri Dec 13 17:20:00 EST 2019
[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-5865:
----------------------------------
Component/s: Query Engine
Description:
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.
was:
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[][]"}}
Fix Version/s: 13.0.1
12.2.2
12.3.1
Sprint: DV Sprint 56
Summary: Error with pg arrays (was: Odata $expand does not work)
> 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
> 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 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