March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3376?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3376. ----------------------------------- Fix Version/s: 8.11 Resolution: Done Added handling for the cast to time from timestamp for 2008+ > SQL Server 2008/2012 - incompatible data types in comparison after cast/convert > ------------------------------------------------------------------------------- > > Key: TEIID-3376 > URL: https://issues.jboss.org/browse/TEIID-3376 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > java: oracle 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > > If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception: > "SQLServerException: The data types datetime and time are incompatible in the greater than operator." > Expected behavior: > The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3364) Teiid Embedded generic-soap run failed

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3364?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3364: ------------------------------------ I have added the following embedded examples: * cassandra-as-a-datasourse * embedded-portfolio * excel-as-a-datasource * generic-soap * hbase-as-a-datasource * ldap-as-a-datasource * mongodb-as-a-datasource * webservices-as-a-datasource it all run fine in my environment. > Teiid Embedded generic-soap run failed > -------------------------------------- > > Key: TEIID-3364 > URL: https://issues.jboss.org/browse/TEIID-3364 > Project: Teiid > Issue Type: Enhancement > Components: Embedded > Reporter: Kylin Soong > Assignee: Kylin Soong > > I test the 8.10 embedded-dist zip download, the generic-soap run failed with Connection reset exception. > On the other sides, can we add more samples for teiid embedded mode? -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3376: ----------------------------------- Summary: SQL Server 2008/2012 - incompatible data types in comparison after cast/convert Key: TEIID-3376 URL: https://issues.jboss.org/browse/TEIID-3376 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1 Environment: OS: fedora 20 java: oracle 1.7 arch: x86_64 Reporter: Juraj Duráni Assignee: Steven Hawkins If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception: "SQLServerException: The data types datetime and time are incompatible in the greater than operator." Expected behavior: The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3372) Support multiple metadata tags

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3372?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3372: ------------------------------------- I do not think this layer is exposed there. > Support multiple metadata tags > ------------------------------ > > Key: TEIID-3372 > URL: https://issues.jboss.org/browse/TEIID-3372 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > To allow for a more flexible configuration, we should support multiple metadata tags under a model, rather than relying on comma separated values. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3372) Support multiple metadata tags

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3372?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3372: --------------------------------------- Updated the logic to support multiple metadata tags. Do we need to maintain any backwards compatibility in the DMR layer? > Support multiple metadata tags > ------------------------------ > > Key: TEIID-3372 > URL: https://issues.jboss.org/browse/TEIID-3372 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > To allow for a more flexible configuration, we should support multiple metadata tags under a model, rather than relying on comma separated values. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3371) Upgrade Teiid with EAP 6.4 Alpha

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3371?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3371: ------------------------------------- Two issues I see are - The BOM version never seems to be inline with root JBoss EAP version. i.e I can not find a BOm version that can do EAP 6.4.0-Alpha and then may be for product EAP 6.4.0.Final. Not sure the BOM is community vs product. The solution here is to move back depend upon the jboss-parent that root of the JBoss-EAP. - I did not find the distribution file for EAP 6.4.0-Alpha in the maven, this will prohibit us from integration tests and as well building the server kit and Docker image. > Upgrade Teiid with EAP 6.4 Alpha > -------------------------------- > > Key: TEIID-3371 > URL: https://issues.jboss.org/browse/TEIID-3371 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.11 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Attachments: diff.txt, status.txt > > > Upgrade all the Teiid projects to be built based on EAP 6.4 Alpha. Currently, this would align with jboss-integration-platform-bom 6.0.0.CR25 and EAP Alpha version 7.5.0.Final-redhat-17. Note, 7.5.0.Final-redhat-17 is the version in the EAP kit, but only CR25 bom is available. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3121. --------------------------------- Fix Version/s: 8.10 (was: Open To Community) Resolution: Done Independent server distribution is now available from the download site. Some some reason I could not assign Tom's name to assignee name > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: 8.10 > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3369) Add a extension point to manipulate incoming sql

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3369?page=com.atlassian.jira.plugin... ] Work on TEIID-3369 started by Steven Hawkins. --------------------------------------------- > Add a extension point to manipulate incoming sql > ------------------------------------------------ > > Key: TEIID-3369 > URL: https://issues.jboss.org/browse/TEIID-3369 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > We should look at adding a client or server extension point for manipulating sql - just the sql string, pre resolving. This will allow more flexibility in dealing with clients that don't send queries directly understood by Teiid. For example a select for update. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3371) Upgrade Teiid with EAP 6.4 Alpha

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3371?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3371: ------------------------------- Attachment: diff.txt status.txt The attached diff.txt and status.txt show the changes that I needed to do to get it to build. > Upgrade Teiid with EAP 6.4 Alpha > -------------------------------- > > Key: TEIID-3371 > URL: https://issues.jboss.org/browse/TEIID-3371 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.11 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Attachments: diff.txt, status.txt > > > Upgrade all the Teiid projects to be built based on EAP 6.4 Alpha. Currently, this would align with jboss-integration-platform-bom 6.0.0.CR25 and EAP Alpha version 7.5.0.Final-redhat-17. Note, 7.5.0.Final-redhat-17 is the version in the EAP kit, but only CR25 bom is available. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3144) Unrelated correlated subquery in order by not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3144?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3144. --------------------------------- > Unrelated correlated subquery in order by not working > ----------------------------------------------------- > > Key: TEIID-3144 > URL: https://issues.jboss.org/browse/TEIID-3144 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > A query such as the one below will fail with a low level exception: > {code} > select * from foo order by (select count(*) from x where x.fid = foo.id) > {code} > We should either validate against or update the logic (probably adding an inline view in the rewriter). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015