August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3585) MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3585?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3585: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1245204|https://bugzilla.redhat.com/show_bug.cgi?id=1245204] from VERIFIED to CLOSED > MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value) > ---------------------------------------------------------------------- > > Key: TEIID-3585 > URL: https://issues.jboss.org/browse/TEIID-3585 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Connector/J version: 5.1.36 > MySQL server version: 5.5.43 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If INSERT statement contains an object value then execution fails with "java.sql.SQLException: Unknown Types value". There is no exception without object value. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3781) Queries are not killed even if the client sends a cancel request

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3781?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3781: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1315378|https://bugzilla.redhat.com/show_bug.cgi?id=1315378] from VERIFIED to CLOSED > Queries are not killed even if the client sends a cancel request > ---------------------------------------------------------------- > > Key: TEIID-3781 > URL: https://issues.jboss.org/browse/TEIID-3781 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.0 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > I have different behaviors when I try to cancel the following queries: > {code:sql} > SELECT COUNT(*) > FROM > (SELECT * FROM my.address) as x1, > (SELECT * FROM my.address) as y1 > {code} > and > {code:sql} > SELECT COUNT(*) > FROM > (SELECT * FROM my.address limit 10000) as x1, > (SELECT * FROM my.address limit 10000) as y1 > {code} > where "my.address" is a table with around 20000 rows in MySQL. > The first query is immediately cancelled but the second one continues to run until the end and it is never killed. > Looking at the generated plans, the main difference is that the first query is fully pushed down to MySQL while the second one is not. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4017: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1314863|https://bugzilla.redhat.com/show_bug.cgi?id=1314863] from VERIFIED to CLOSED > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.13.2, 8.7.5.6_2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3929) Accumulo does not return null values

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3929?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3929: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1301527|https://bugzilla.redhat.com/show_bug.cgi?id=1301527] from VERIFIED to CLOSED > Accumulo does not return null values > ------------------------------------ > > Key: TEIID-3929 > URL: https://issues.jboss.org/browse/TEIID-3929 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.3 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Accumulo doesn't return null values when a whole 'column' is being selected. > For a command in accumulo shell like: > {code:plain} > scan -c name:BYTENUM > {code} > Accumulo returns only non-empty values, this is expected behaviour. > Equivalent query in Teiid would be: > {code:sql} > SELECT ByteNum FROM SmallA > {code} > Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4042) OData returns status code 200 instead of 204 if there are no expanded entities

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4042?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4042: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316473|https://bugzilla.redhat.com/show_bug.cgi?id=1316473] from VERIFIED to CLOSED > OData returns status code 200 instead of 204 if there are no expanded entities > ------------------------------------------------------------------------------- > > Key: TEIID-4042 > URL: https://issues.jboss.org/browse/TEIID-4042 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers(4)/Orders_FK0 > *Returned status code:* 200 > *Expected:* 204 and empty body > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3767) HBase - Phoenix does not support LIKE ESCAPE

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3767?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3767: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1272877|https://bugzilla.redhat.com/show_bug.cgi?id=1272877] from VERIFIED to CLOSED > HBase - Phoenix does not support LIKE ESCAPE > -------------------------------------------- > > Key: TEIID-3767 > URL: https://issues.jboss.org/browse/TEIID-3767 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Phoenix does not support LIKE ESCAPE. There is hardcoded escape character \. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3922) Accumulo translator needs defined dependency to "org.jboss.teiid" module

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3922?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3922: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1301065|https://bugzilla.redhat.com/show_bug.cgi?id=1301065] from VERIFIED to CLOSED > Accumulo translator needs defined dependency to "org.jboss.teiid" module > ------------------------------------------------------------------------ > > Key: TEIID-3922 > URL: https://issues.jboss.org/browse/TEIID-3922 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.3 > Reporter: Jan Stastny > Assignee: Jan Stastny > Fix For: 8.13, 8.12.5 > > > When using Accumulo translator to query an accumulo instance, following exception appears, when comparing on a column. > {code} > Caused by: java.lang.ClassNotFoundException: org.teiid.api.exception.query.ExpressionEvaluationException > {code} > Example query: > {code:sql} > SELECT * FROM MyTable WHERE MyColumn='string'; > {code} > The reason is, that the mentioned class ExpressionEvaluationException is placed in module "org.jboss.teiid", but this module is not set as dependency in resulting "org.jboss.teiid.translator.accumulo" module. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3022) refine removed vdb handling

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3022?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3022: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1291719|https://bugzilla.redhat.com/show_bug.cgi?id=1291719] from VERIFIED to CLOSED > refine removed vdb handling > --------------------------- > > Key: TEIID-3022 > URL: https://issues.jboss.org/browse/TEIID-3022 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Affects Versions: 8.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8 > > > With TEIID-2105 the server will reject requests against a non-active vdb, which includes a removed vdb. This is against the original intent of allowing for lazy cleanup. We should either have a vdb remove proactively terminate all sessions and fully cleanup or we should reinstate the lazy logic. At this point it probably makes the most sense to go the first route as there is other logic (materialization management for one) now checking the vdb state and assuming that removal will invalidate the vdb. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3906) OData v4 - definition of OData-Isolation header is either being ignored or is not implemented correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3906?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3906: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1298916|https://bugzilla.redhat.com/show_bug.cgi?id=1298916] from VERIFIED to CLOSED > OData v4 - definition of OData-Isolation header is either being ignored or is not implemented correctly > ------------------------------------------------------------------------------------------------------- > > Key: TEIID-3906 > URL: https://issues.jboss.org/browse/TEIID-3906 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.3 > Environment: Teiid - OData v4 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Teiid does not process header *OData-Isolation: snapshot* defined in request correctly. > * if service (Teiid) does not support this option it must return error 412 > * if Teiid does supports this option then it is not processed correctly, because modifications made during request are visbile > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3888?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3888: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1296599|https://bugzilla.redhat.com/show_bug.cgi?id=1296599] from VERIFIED to CLOSED > Redshift - there is not function SUBSTR (RS uses SUBSTRING) > ----------------------------------------------------------- > > Key: TEIID-3888 > URL: https://issues.jboss.org/browse/TEIID-3888 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.3 > Environment: driver - PostgreSQL 9.2 > translator - postgresql > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > Postgresql translator uses SUBSTR function to get substring of string (e.g. function LEFT(x,y)), but Redshift does not support function SUBSTR. It support SUBSTRING function instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 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 August 2016