November 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5172) Missing message for key "TEIID31262"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5172?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5172. ----------------------------------- Fix Version/s: 10.1 10.0.1 9.3.6 Resolution: Done Thanks, Andrej the message has been corrected. > Missing message for key "TEIID31262" > ------------------------------------ > > Key: TEIID-5172 > URL: https://issues.jboss.org/browse/TEIID-5172 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 10.1, 10.0.1, 9.3.6 > > > When creating tests for TEIID-4557, I ran into missing message for an exception: > {noformat} > [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue200) TEIID30019 Unexpected exception for request oekxHV8aThTk.100: org.teiid.core.TeiidComponentException: TEIID31261 TEIID31262 <Missing message for key "TEIID31262" in: org.teiid.query.i18n> > {noformat} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5171) Forward navigation of expand returns wrong results.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5171?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5171. ----------------------------------- Resolution: Done Addressed by cleaning up the logic around creating join predicates so that we more completely considered the direction. This also allowed you to share that logic with another code path. There was a minor clean up of navigation nullability - as it is not required to be not null. > Forward navigation of expand returns wrong results. > --------------------------------------------------- > > Key: TEIID-5171 > URL: https://issues.jboss.org/browse/TEIID-5171 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.x-6.4, 10.1, 10.0.1, 9.3.6 > > > On a self relationship expand, the reverse navigation will return the correct result: > Employee?$expand=Employee_FK0 > But the same result will be returned for the forward as well: > Employee?$expand=FK0 > The logic is not differentiating between the directions. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5172) Missing message for key "TEIID31262"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5172?page=com.atlassian.jira.plugin... ] Work on TEIID-5172 started by Steven Hawkins. --------------------------------------------- > Missing message for key "TEIID31262" > ------------------------------------ > > Key: TEIID-5172 > URL: https://issues.jboss.org/browse/TEIID-5172 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > > When creating tests for TEIID-4557, I ran into missing message for an exception: > {noformat} > [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue200) TEIID30019 Unexpected exception for request oekxHV8aThTk.100: org.teiid.core.TeiidComponentException: TEIID31261 TEIID31262 <Missing message for key "TEIID31262" in: org.teiid.query.i18n> > {noformat} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5171) Forward navigation of expand returns wrong results.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5171?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5171: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1518280|https://bugzilla.redhat.com/show_bug.cgi?id=1518280] from NEW to MODIFIED > Forward navigation of expand returns wrong results. > --------------------------------------------------- > > Key: TEIID-5171 > URL: https://issues.jboss.org/browse/TEIID-5171 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.x-6.4, 10.1, 10.0.1, 9.3.6 > > > On a self relationship expand, the reverse navigation will return the correct result: > Employee?$expand=Employee_FK0 > But the same result will be returned for the forward as well: > Employee?$expand=FK0 > The logic is not differentiating between the directions. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5173) Swagger API mixup

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5173?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5173. ----------------------------------- Resolution: Done In looking at the related issues the closest fix was to inject a functional config based upon the filter config. This required creating a custom api listing. > Swagger API mixup > ----------------- > > Key: TEIID-5173 > URL: https://issues.jboss.org/browse/TEIID-5173 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 10.1, 10.0.1, 9.3.6 > > > See https://stackoverflow.com/questions/47427901/teiid-generated-swagger-json... > If two swagger VDBs are deployed only one results will be returned for both: > .../vdb1/swagger.json > and > .../vdb2/swagger.json > This seems related to https://github.com/swagger-api/swagger-core/issues/1514 and https://github.com/swagger-api/swagger-core/issues/1691 is reported on the console. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5168) PrestoDB translator - Convert to float not pushed correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5168?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5168: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1517884, https://bugzilla.redhat.com/show_bug.cgi?id=1515768 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1515768) > PrestoDB translator - Convert to float not pushed correctly > ----------------------------------------------------------- > > Key: TEIID-5168 > URL: https://issues.jboss.org/browse/TEIID-5168 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 10.1 > > > Running query such as > {code:sql} > SELECT StringKey, (convert(StringKey, float)+3) FROM BQT1.SmallA > {code} > Fails with the following exception: > {noformat} > org.teiid.translator.jdbc.JDBCExecutionException: 1 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.stringkey AS c_0, (g_0.stringkey + 3.0) AS c_1 FROM smalla AS g_0 LIMIT 100] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) > at sun.reflect.GeneratedMethodAccessor171.invoke(Unknown Source) [:1.8.0_141] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy80.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141] > at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141] > Caused by: java.sql.SQLException: Query failed (#20171121_110032_00034_8zhqn): line 1:45: '+' cannot be applied to varchar(10), double > at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799) > at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1747) > at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:125) > at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:212) > at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69) > at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] > ... 17 more > {noformat} > The query is translated as (note missing convert) > {code:sql} > SELECT g_0.stringkey AS c_0, (g_0.stringkey + 3.0) AS c_1 FROM smalla AS g_0 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5174) Filter internal constructs from oracle metadata

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5174: ------------------------------------- Summary: Filter internal constructs from oracle metadata Key: TEIID-5174 URL: https://issues.jboss.org/browse/TEIID-5174 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.1 Even with the import table types set to TABLE, an Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 accessed with the 12.1.0.1.0 driver will contain internal tables which will cause the deployment to error: TEIID31071 Invalid table; Table oracleModel.HS_PARTITION_COL_NAME has no columns defined It would be good if these were filtered by default. The workaround is to specify a schema or regex to prevent such tables from being imported. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5173) Swagger API mixup

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5173: ------------------------------------- Summary: Swagger API mixup Key: TEIID-5173 URL: https://issues.jboss.org/browse/TEIID-5173 Project: Teiid Issue Type: Bug Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 10.1, 10.0.1, 9.3.6 See https://stackoverflow.com/questions/47427901/teiid-generated-swagger-json... If two swagger VDBs are deployed only one results will be returned for both: .../vdb1/swagger.json and .../vdb2/swagger.json This seems related to https://github.com/swagger-api/swagger-core/issues/1514 and https://github.com/swagger-api/swagger-core/issues/1691 is reported on the console. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4269) numeric calculated fields not displayed with odata4

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4269?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4269: --------------------------------------- [~jstastny] TEIID-5063 changed the test to use 12.30. If you use 12.31, it will fail. > numeric calculated fields not displayed with odata4 > --------------------------------------------------- > > Key: TEIID-4269 > URL: https://issues.jboss.org/browse/TEIID-4269 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Mirco Marchitiello > Assignee: Ramesh Reddy > Fix For: 9.1, 8.12.x-6.4 > > > I've created a virtual table with a new field defined in this way: > select ROUND((BA.PREIS / BA.PEINH), 3) AS UnitPrice from xxxxxx > for the source field are bigdecimal I define UnitPrice as > BigDecimal (13,3) > If I run the qery from JDBC > select * from PurchaseRequisitionEntity where PurchaseRequisitionKey = '300-8000001452-00010' ; > PREIS = 539,568 > PEINH = 106 > UnitPrice = 5,090.264 > And the result is correct. If I run from odata2 > /odata/CASALE.1/Entities.PurchaseRequisitionEntity('300-8000001452-00010')?$format=json > "UnitPrice" : "5090.2640000000000000" > As you can see the field is rounded to the 3rd digit but 13 more digits are returned with 0 value. > Anyway odata2 succeeds in returning the result without errors. > With odata4 I get an error: > /odata4/CASALE.1/Entities/PurchaseRequisitionEntity('300-8000001452-00010')?$format=json > {"error":{"code":null,"message":"The value '5090.2640000000000000' is not valid for property 'UnitPrice'."}} > I think that's because the length of the field is greater then the matedata definition. > At the moment the only solution I can imagine is to convert the number to a string in the proper format and the parse it into a number -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5171) Forward navigation of expand returns wrong results.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5171?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5171: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Forward navigation of expand returns wrong results. > --------------------------------------------------- > > Key: TEIID-5171 > URL: https://issues.jboss.org/browse/TEIID-5171 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.x-6.4, 10.1, 10.0.1, 9.3.6 > > > On a self relationship expand, the reverse navigation will return the correct result: > Employee?$expand=Employee_FK0 > But the same result will be returned for the forward as well: > Employee?$expand=FK0 > The logic is not differentiating between the directions. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 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 November 2017