December 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5862) TEIID-5314 does not account for env key name restrictions

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5862?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5862. ----------------------------------- Resolution: Done Changed the logic to handle env properties separately so that we can tell when to check with snake case. Added a doc note about this as well. > TEIID-5314 does not account for env key name restrictions > ---------------------------------------------------------- > > Key: TEIID-5862 > URL: https://issues.redhat.com/browse/TEIID-5862 > Project: Teiid > Issue Type: Quality Risk > Components: Common > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.0 > > Original Estimate: 4 hours > Time Spent: 4 hours > Remaining Estimate: 0 minutes > > The logic introduced in TEIID-5314 assumes that env variables can be referenced with existing teiid keys. This was supposed to work with thorntail, but I think that it would have needed to either preprocess the env and populate additional system properties, or otherwise manipulate the env keys. In any event the logic is not sound in general. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 4 months

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

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

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)

6 years, 4 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2019