June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4129: --------------------------------------- Added another system property org.teiid.assumeMatchingCollation with the release note: In order to prevent seemingly invalid results from a sort/merge join, the sort operation will undergo additional checks. If org.teiid.assumeMatchingCollation is false (the default) and a translator does not specify a collationLocale, then the sort for a sort/merge join will not be pushed. Teiid defaults to the Java UCS-2 collation, which may not match the default collation for sources, particular tables, or columns. You may set the system property org.teiid.assumeMatchingCollation true to restore the old default behavior or selectively update the translators to report a collationLocale matching org.teiid.collationLocale (UCS-2 if unset). So we'll effectively default to not pushing down sorts for join processing that involve character data. > Wrong results with cross model join on 2 varchar fields > ------------------------------------------------------- > > Key: TEIID-4129 > URL: https://issues.jboss.org/browse/TEIID-4129 > Project: Teiid > Issue Type: Bug > Reporter: Mark Tawk > Assignee: Steven Hawkins > Attachments: H2 DBs.zip, MetaDataStores.zip > > > I'm using Teiid 8.11.3 with H2 translator. > I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields. > the query result is retuning empty values from the joined table even though the joined values are identical. > You find attached a zip file containing 2 h2 DBs for a simplified example > Here is the query used: > _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID" > from "db2"."Customer" "Customer" > LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_ > Note that if the 2 tables are in the same model, the query return correct results. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4296) File translator cannot find a file without an extensioin

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4296?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4296: ------------------------------------- Fix Version/s: 9.1 Assignee: (was: Steven Hawkins) > File translator cannot find a file without an extensioin > -------------------------------------------------------- > > Key: TEIID-4296 > URL: https://issues.jboss.org/browse/TEIID-4296 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Fix For: 9.1 > > > Spark creates files with no extension, so using the following: > EXEC Spark.getTextFiles('part-00001') will generate an error when trying any of the following ways: part-*.* or part*.* or part-* > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Spark: File not found part*.* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4296) File translator cannot find a file without an extensioin

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4296?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4296: ------------------------------- Issue Type: Feature Request (was: Enhancement) > File translator cannot find a file without an extensioin > -------------------------------------------------------- > > Key: TEIID-4296 > URL: https://issues.jboss.org/browse/TEIID-4296 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Spark creates files with no extension, so using the following: > EXEC Spark.getTextFiles('part-00001') will generate an error when trying any of the following ways: part-*.* or part*.* or part-* > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Spark: File not found part*.* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4296) File translator cannot find a file without an extensioin

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4296?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4296: ------------------------------- Issue Type: Enhancement (was: Bug) > File translator cannot find a file without an extensioin > -------------------------------------------------------- > > Key: TEIID-4296 > URL: https://issues.jboss.org/browse/TEIID-4296 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Spark creates files with no extension, so using the following: > EXEC Spark.getTextFiles('part-00001') will generate an error when trying any of the following ways: part-*.* or part*.* or part-* > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Spark: File not found part*.* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4296) File translator cannot find a file without an extensioin

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4296?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4296: --------------------------------------- That is expected. The wildcard is for the extension. This would be a new feature to support arbitrary file name patterns. > File translator cannot find a file without an extensioin > -------------------------------------------------------- > > Key: TEIID-4296 > URL: https://issues.jboss.org/browse/TEIID-4296 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Spark creates files with no extension, so using the following: > EXEC Spark.getTextFiles('part-00001') will generate an error when trying any of the following ways: part-*.* or part*.* or part-* > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Spark: File not found part*.* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4296) File translator cannot find a file without an extensioin

by Van Halbert (JIRA)

Van Halbert created TEIID-4296: ---------------------------------- Summary: File translator cannot find a file without an extensioin Key: TEIID-4296 URL: https://issues.jboss.org/browse/TEIID-4296 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Van Halbert Assignee: Steven Hawkins Spark creates files with no extension, so using the following: EXEC Spark.getTextFiles('part-00001') will generate an error when trying any of the following ways: part-*.* or part*.* or part-* org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Spark: File not found part*.* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4278) MySQL 5 should support distinct aggregates

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4278: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1349560, https://bugzilla.redhat.com/show_bug.cgi?id=1349562 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1349560) > MySQL 5 should support distinct aggregates > ------------------------------------------ > > Key: TEIID-4278 > URL: https://issues.jboss.org/browse/TEIID-4278 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4278) MySQL 5 should support distinct aggregates

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4278: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1349560 Bugzilla Update: Perform > MySQL 5 should support distinct aggregates > ------------------------------------------ > > Key: TEIID-4278 > URL: https://issues.jboss.org/browse/TEIID-4278 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4295) TEIID31150 when using date function with MSSQL

by Mark Tawk (JIRA)

Mark Tawk created TEIID-4295: -------------------------------- Summary: TEIID31150 when using date function with MSSQL Key: TEIID-4295 URL: https://issues.jboss.org/browse/TEIID-4295 Project: Teiid Issue Type: Feature Request Reporter: Mark Tawk Assignee: Steven Hawkins I'm using teiid version 8.11.3 I have a field of type date over mssql 2012, when applying a date function over it, i get directly the error : org.teiid.jdbc.TeiidSQLException: TEIID31150 The function 'YEAR(testmark.mydate)' is ambiguous. Use schema qualification. if I change the field type to datetime, the query executes successfully. Here is the simplified query i'm testing with: select YEAR("testmark"."mydate") as "testmark_mydate" from "implify_dataModel_at"."implify_data"."implify_red2"."testmark" "testmark" LIMIT 0 , 10 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4200: ------------------------------------- Added the initial code to move the host environment to the WildFly 10 One major behavior change I see is data source creation and deletion now requires a server restart, that means we do not get notifications of data source removed to change the VDB validity correctly. So, even though the data source is deleted the VDB status will be "valid". May be we should look into redoing the validity of VDB. I still need to update web-console version update. [~kylin] Can you see if you can test this and see if I missed anything, you can comment here with issues, do not open a new JIRA as I will keep this open for little while. > Provide support for Wildfly 10 > ------------------------------ > > Key: TEIID-4200 > URL: https://issues.jboss.org/browse/TEIID-4200 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.1 > > > Upgrade the host runtime environment for Teiid Server to be WildFly 10. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

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