March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2785) Designer needs a way to utilize pushdown functions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2785?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2785: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1045206|https://bugzilla.redhat.com/show_bug.cgi?id=1045206] from MODIFIED to ON_QA > Designer needs a way to utilize pushdown functions > -------------------------------------------------- > > Key: TEIID-2785 > URL: https://issues.jboss.org/browse/TEIID-2785 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7 > > > Pushdown functions, such as the ones exposed by the ModeShapeExecutionFactory, should be available at design time. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3559) Refactor Object and Infinispan translator / connectors

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3559?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3559: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1197789|https://bugzilla.redhat.com/show_bug.cgi?id=1197789] from MODIFIED to ON_QA > Refactor Object and Infinispan translator / connectors > ------------------------------------------------------ > > Key: TEIID-3559 > URL: https://issues.jboss.org/browse/TEIID-3559 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Optional > Fix For: 9.0, 8.12.5 > > > Now that JDG has reworked its remote-cache and changed (reduced) what dependencies its exposed, there's now more common code between the object/infinispan-cache translator/connector and the infinispan-cache-dsl translator/connector. I think refactoring can eliminate issues with support and ensure common behavior across all the code. > Where is common code seen: > - searching (i.e., DSLSearch) > - updates (InfinispanUpdateExecution) > - ClassRegistry > (for starters) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3345) NPE while accessing VDB via OData access

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3345?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3345: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1194292|https://bugzilla.redhat.com/show_bug.cgi?id=1194292] from MODIFIED to ON_QA > NPE while accessing VDB via OData access > ---------------------------------------- > > Key: TEIID-3345 > URL: https://issues.jboss.org/browse/TEIID-3345 > Project: Teiid > Issue Type: Bug > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Priority: Minor > Labels: Alpha1 > Fix For: 8.11 > > > If wrong odata URL is provided, an internal error is displayed: > URL: http://localhost:8080/odata/ > Exception: org.teiid.core.TeiidRuntimeException: TEIID16008 VDB name not defined on the URL. The url format is http://{host}:{port}/odata/{vdb-name}[.{vdb-version}]/... > org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:88) > org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:47) > .... > This behavior is quite expected. > URL: http://localhost:8080/odata > Exception: java.lang.NullPointerException > org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:80) > org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:47) > ... > I expect that teiid should return similar exception -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3281: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1180144|https://bugzilla.redhat.com/show_bug.cgi?id=1180144] from MODIFIED to ON_QA > MongoDB: EmptyStackException when joining tables > ------------------------------------------------ > > Key: TEIID-3281 > URL: https://issues.jboss.org/browse/TEIID-3281 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: CR2 > Fix For: 8.10 > > Attachments: mongodb-vdb.xml, server.log > > > Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled. > Example: > {code} > insert into customer2 values(1,'Pepa', 'Koukal'); > insert into customer2 values(2,'Jan', 'Tlemil'); > insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode'); > insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode'); > {code} > {code} > select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID > {code} > {code} > Error: > java.util.EmptyStackException > at java.util.Stack.peek(Stack.java:102) > at java.util.Stack.pop(Stack.java:84) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993) > at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) > at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112) > {code} > VDB and log are in the attachment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3340) JDBC direct query execution binding is incorrect

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3340?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3340: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1226323|https://bugzilla.redhat.com/show_bug.cgi?id=1226323] from MODIFIED to ON_QA > JDBC direct query execution binding is incorrect > ------------------------------------------------ > > Key: TEIID-3340 > URL: https://issues.jboss.org/browse/TEIID-3340 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The binding logic is passing the literal and the 0 based index, when it should be passing the literal value and the 1 based index. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3501) IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3501?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3501: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1226824|https://bugzilla.redhat.com/show_bug.cgi?id=1226824] from MODIFIED to ON_QA > IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)" > -------------------------------------------------------------------------------- > > Key: TEIID-3501 > URL: https://issues.jboss.org/browse/TEIID-3501 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: teradata version: 15 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.2 > > > The teradata DB does not support CAST statement in IN. Query (1), teradata exception (2), source specific command (3), query that teradata accepts (4). > (1) SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimeStampValue IN (convert('2000-01-01 00:00:12.0', timestamp), convert('2000-01-01 00:00:45.0', timestamp)) ORDER BY IntKey > (2) SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.timestampvalue IN (cast('2000-01-01 00:00:12.0' AS TIMESTAMP(6)), cast('2000-01-01 00:00:45.0' AS TIMESTAMP(6))) ORDER BY 1 > (3) SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.timestampvalue IN ('2000-01-01 00:00:12.0', '2000-01-01 00:00:45.0') ORDER BY 1 > (4) Caused by: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.05] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','. > at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308) > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3527) Missing ODBC port number in the log during shutdown

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3527?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3527: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1231613|https://bugzilla.redhat.com/show_bug.cgi?id=1231613] from MODIFIED to ON_QA > Missing ODBC port number in the log during shutdown > --------------------------------------------------- > > Key: TEIID-3527 > URL: https://issues.jboss.org/browse/TEIID-3527 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Trivial > Fix For: 8.11 > > > There is missing ODBC port number in the log during shutdown: > INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50039 Teiid JDBC - Name = jdbc, Host = localhost, Port = 31000 has been shutdown. > INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50040 Teiid ODBC - Name = localhost, Host = 35432, Port = {2} has been shutdown. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3505) MySQL translator (mysql, mysql5) - convert( ..., float [double]) uses "+ 0.0" construction

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3505?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3505: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1227214|https://bugzilla.redhat.com/show_bug.cgi?id=1227214] from MODIFIED to ON_QA > MySQL translator (mysql, mysql5) - convert( ..., float [double]) uses "+ 0.0" construction > ------------------------------------------------------------------------------------------- > > Key: TEIID-3505 > URL: https://issues.jboss.org/browse/TEIID-3505 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > > convert(... , float) and convert(..., double) functions use for conversion "+ 0.0". But if the result is used in the more complex expression, translator does not take into account priority of the operators. > *Query:* SELECT StringKey, (convert(StringKey, float)+(-3)) AS StringKeyPlusNeg3, (convert(StringKey, float) - (-3)) AS StringKeyMinusNeg3, (convert(StringKey, float)*(-3)) AS StringKeyTimesNeg3, (convert(StringKey, float)/(-3)) AS StringKeyDivNeg3 FROM table WHERE IntKey == 1 ORDER BY StringKey > *Result:* 1 | -2 | 4 | 1 | 1 > *Source-specific query:* SELECT g_0.STRINGKEY AS c_0, (g_0.STRINGKEY + 0.0 + -3.0) AS c_1, (g_0.STRINGKEY + 0.0 - -3.0) AS c_2, _*(g_0.STRINGKEY + 0.0 * -3.0)*_ AS c_3, _*(g_0.STRINGKEY + 0.0 / -3.0)*_ AS c_4 FROM smalla AS g_0 WHERE g_0.INTKEY > 0 AND g_0.INTKEY <= 10 ORDER BY c_0 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3562) Teradata15 - teiid shifts date/time/timestamp values according to timezone.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3562?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3562: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1240565|https://bugzilla.redhat.com/show_bug.cgi?id=1240565] from MODIFIED to ON_QA > Teradata15 - teiid shifts date/time/timestamp values according to timezone. > --------------------------------------------------------------------------- > > Key: TEIID-3562 > URL: https://issues.jboss.org/browse/TEIID-3562 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: teradata version - 15.00.01.01 > teradata driver version - 15.10.00.05 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > Attachments: Main.java, out_GMT+0500, out_GMT_not_set > > > Teiid shifts date/time/timestamp values returned from teradata according to user.timezone value [1], [2]. However, when I execute source-specific command, teradata returns correct values [3]. > [1] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+5 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 19:00:00 | 1999-12-31 19:00:00.0| > |1 | 2000-01-01 | 20:00:00 | 1999-12-31 19:00:01.0| > |2 | 2000-01-02 | 21:00:00 | 1999-12-31 19:00:02.0| > |3 | 2000-01-03 | 22:00:00 | 1999-12-31 19:00:03.0| > |...|...|...|...| > [2] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+1 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 23:00:00 | 1999-12-31 23:00:00.0| > |1 | 2000-01-01 | 00:00:00 | 1999-12-31 23:00:01.0| > |2 | 2000-01-02 | 01:00:00 | 1999-12-31 23:00:02.0| > |3 | 2000-01-03 | 02:00:00 | 1999-12-31 23:00:03.0| > |...|...|...|...| > [3] > *Query:* SELECT g_0.IntKey AS c_0, g_0.DateValue AS c_1, g_0.TimeValue AS c_2, g_0.TimestampValue AS c_3 FROM smalla AS g_0 ORDER BY 1 > *local timezone:* GMT+1/GMT+5 > *Result:* > || c_0 || c_1 || c_2 || c_3 || > |0 | 2000-01-01 | 00:00:00 | 2000-01-01 00:00:00.0| > |1 | 2000-01-02 | 01:00:00 | 2000-01-01 00:00:01.0| > |2 | 2000-01-03 | 02:00:00 | 2000-01-01 00:00:02.0| > |3 | 2000-01-04 | 03:00:00 | 2000-01-01 00:00:03.0| > |...|...|...|...| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3528) Solr translator - batched update with more than one query gets stack

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3528?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3528: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1231769|https://bugzilla.redhat.com/show_bug.cgi?id=1231769] from MODIFIED to ON_QA > Solr translator - batched update with more than one query gets stack > -------------------------------------------------------------------- > > Key: TEIID-3528 > URL: https://issues.jboss.org/browse/TEIID-3528 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > Attachments: server.log > > > PreparedStatement.executeBatch() with more than one query gets stack (but data are stored in Solr). For more details see server.log. > However batch of size 1 and Statement.executeBatch() run without problems. > The issue is not present in 6.1.1 version. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016