December 2019 - teiid-issues - Jboss List Archives

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5865: ---------------------------------- Description: When I try the following query using customer-dv deployment against postgresql https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... 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[][]"}} was: When I try the following query using customer-dv deployment https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... 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[][]"}} > 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 > 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.ope... > 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)

5 years, 1 month

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5865: ---------------------------------- Description: When I try the following query using customer-dv deployment https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... 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[][]"}} was: $expand is standard OData query option. It is not listed as not-supported in our docs, so I assume it is supported When I try the following query using customer-dv deployment https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... 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[][]"}} Affects Version/s: 12.3 > 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 > Priority: Minor > > When I try the following query using customer-dv deployment > https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... > 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)

5 years, 1 month

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5865: ---------------------------------- Priority: Major (was: Minor) > 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 > Priority: Major > > When I try the following query using customer-dv deployment > https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... > 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)

5 years, 1 month

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5865?page=com.atlassian.jira.plugi... ] Steven Hawkins moved ENTESB-12458 to TEIID-5865: ------------------------------------------------ Project: Teiid (was: Red Hat Fuse) Key: TEIID-5865 (was: ENTESB-12458) Workflow: classic default workflow (was: ENTESB Planned Work) Component/s: OData (was: Data Integration) Affects Version/s: (was: fuse-7.5-GA) > Odata $expand does not work > --------------------------- > > Key: TEIID-5865 > URL: https://issues.redhat.com/browse/TEIID-5865 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Priority: Minor > > $expand is standard OData query option. It is not listed as not-supported in our docs, so I assume it is supported > When I try the following query using customer-dv deployment > https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.ope... > 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)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5864) Teiid Query Join Plan Infinite Loop

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5864?focusedWorklogId=12448395&pag... ] Steven Hawkins logged work on TEIID-5864: ----------------------------------------- Author: Steven Hawkins Created on: 07/Dec/19 10:29 AM Start Date: 07/Dec/19 10:29 AM Worklog Time Spent: 4 hours Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 3 hours) Time Spent: 5 hours (was: 1 hour) Worklog Id: (was: 12448395) > Teiid Query Join Plan Infinite Loop > ----------------------------------- > > Key: TEIID-5864 > URL: https://issues.redhat.com/browse/TEIID-5864 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Mark Tawk > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.0, 12.2.2, 12.3.1 > > Original Estimate: 4 hours > Time Spent: 5 hours > Remaining Estimate: 0 minutes > > We are getting an infinite loop when executing the below SQL: > {code:java} > SELECT c._COMPTE, > u.CalculatedField, > cl.CHAMPSFCP__VALEUR, > ch_41.CH41__VALEUR, > ch_5.CH5__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CPARTFCP c > LEFT JOIN BInv6BusinessModel.FREPACCOUNTUNION u > ON u.FREP_AFAINB = c._USERNAME > AND u.CalculatedField6 = 'B' > LEFT JOIN BInv6BusinessModel.ClientTypeCode cl > ON c._COMPTE = cl.CHAMPSFCP__COMPTE > LEFT JOIN (SELECT ch._COMPTE AS CH41__COMPTE, > ch._VALEUR AS CH41__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch > WHERE ch._NUMCHAMPS = 41) ch_41 > ON c._COMPTE = ch_41.CH41__COMPTE > LEFT JOIN (SELECT ch._COMPTE AS CH5__COMPTE, > ch._VALEUR AS CH5__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch > WHERE ch._NUMCHAMPS = 5) ch_5 > ON c._COMPTE = ch_5.CH5__COMPTE LIMIT 0, 10 > {code} > After debugging, find out that the issue is coming from the class RulePlanOuterJoins method planLeftOuterJoinAssociativityBeforePlanning. > the issue is coming from the below code line, if removed the issue is not reproduced: > {code:java} > changedAny |= val; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5864) Teiid Query Join Plan Infinite Loop

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5864?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5864. ----------------------------------- Resolution: Done Took several approaches that didn't quite address this before adding a better guard for attempting the re-arrangement in the first place. > Teiid Query Join Plan Infinite Loop > ----------------------------------- > > Key: TEIID-5864 > URL: https://issues.redhat.com/browse/TEIID-5864 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Mark Tawk > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.0, 12.2.2, 12.3.1 > > Original Estimate: 4 hours > Time Spent: 1 hour > Remaining Estimate: 3 hours > > We are getting an infinite loop when executing the below SQL: > {code:java} > SELECT c._COMPTE, > u.CalculatedField, > cl.CHAMPSFCP__VALEUR, > ch_41.CH41__VALEUR, > ch_5.CH5__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CPARTFCP c > LEFT JOIN BInv6BusinessModel.FREPACCOUNTUNION u > ON u.FREP_AFAINB = c._USERNAME > AND u.CalculatedField6 = 'B' > LEFT JOIN BInv6BusinessModel.ClientTypeCode cl > ON c._COMPTE = cl.CHAMPSFCP__COMPTE > LEFT JOIN (SELECT ch._COMPTE AS CH41__COMPTE, > ch._VALEUR AS CH41__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch > WHERE ch._NUMCHAMPS = 41) ch_41 > ON c._COMPTE = ch_41.CH41__COMPTE > LEFT JOIN (SELECT ch._COMPTE AS CH5__COMPTE, > ch._VALEUR AS CH5__VALEUR > FROM OmgModel_Z1rP.OMG.dbo.CHAMPSFCP ch > WHERE ch._NUMCHAMPS = 5) ch_5 > ON c._COMPTE = ch_5.CH5__COMPTE LIMIT 0, 10 > {code} > After debugging, find out that the issue is coming from the class RulePlanOuterJoins method planLeftOuterJoinAssociativityBeforePlanning. > the issue is coming from the below code line, if removed the issue is not reproduced: > {code:java} > changedAny |= val; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5835) Upgrade Apache Olingo to a final version of 4.7

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5835?page=com.atlassian.jira.plugi... ] Work on TEIID-5835 started by Ramesh Reddy. ------------------------------------------- > Upgrade Apache Olingo to a final version of 4.7 > ----------------------------------------------- > > Key: TEIID-5835 > URL: https://issues.redhat.com/browse/TEIID-5835 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 13.x > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Major > Fix For: 13.0 > > Original Estimate: 1 hour > Remaining Estimate: 0 minutes > > Teiid needs to upgrade from the olingo 4.7 SNAPSHOT. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-136) Allow translator properties to be set via application.properties

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-136?page=com.atlassian.jira.plug... ] Ramesh Reddy updated TEIIDSB-136: --------------------------------- Remaining Estimate: 0 minutes (was: 4 hours) > Allow translator properties to be set via application.properties > ---------------------------------------------------------------- > > Key: TEIIDSB-136 > URL: https://issues.redhat.com/browse/TEIIDSB-136 > Project: Teiid Spring Boot > Issue Type: Enhancement > Components: core, datasource, examples > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Fix For: 1.3.0 > > Original Estimate: 4 hours > Remaining Estimate: 0 minutes > > When using a vdb-less deployment, import/model properties can be set from spring.datasource. or spring.xa.datasource. properties. However translator properties cannot. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-136) Allow translator properties to be set via application.properties

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-136?page=com.atlassian.jira.plug... ] Ramesh Reddy resolved TEIIDSB-136. ---------------------------------- Resolution: Done > Allow translator properties to be set via application.properties > ---------------------------------------------------------------- > > Key: TEIIDSB-136 > URL: https://issues.redhat.com/browse/TEIIDSB-136 > Project: Teiid Spring Boot > Issue Type: Enhancement > Components: core, datasource, examples > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Fix For: 1.3.0 > > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > When using a vdb-less deployment, import/model properties can be set from spring.datasource. or spring.xa.datasource. properties. However translator properties cannot. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5835) Upgrade Apache Olingo to a final version of 4.7

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5835?page=com.atlassian.jira.plugi... ] Ramesh Reddy edited comment on TEIID-5835 at 12/6/19 9:46 PM: -------------------------------------------------------------- When I updated to 4.7 snapshot I did upgrade, I did not see fail. I ran local build too before commiting not sure where it is falling Maybe I did the update in Teiid Spring Boot not in Teiid. :( was (Author: rareddy): When I updated to 4.7 snapshot I did upgrade, I did not see fail. I ran local build too before commiting not sure where it is falling > Upgrade Apache Olingo to a final version of 4.7 > ----------------------------------------------- > > Key: TEIID-5835 > URL: https://issues.redhat.com/browse/TEIID-5835 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 13.x > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Major > Fix For: 13.0 > > Original Estimate: 1 hour > Remaining Estimate: 0 minutes > > Teiid needs to upgrade from the olingo 4.7 SNAPSHOT. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2019