September 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3115) Invalid Query With OrderBy in SubQuery Table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3115?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3115: ---------------------------------- Fix Version/s: 8.7.1 > Invalid Query With OrderBy in SubQuery Table > -------------------------------------------- > > Key: TEIID-3115 > URL: https://issues.jboss.org/browse/TEIID-3115 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.8 > Reporter: Joseph CHIDIAC > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > Hi, I'm using Teiid Embedded Server , i tried to execute the Following query : > > SELECT jiraissue.issuetype > FROM imOrganizationjiraissue jiraissue > LEFT OUTER JOIN > (SELECT jiraissue_sub.issuetype AS jiraissue_issuetype, > AVG( > TIMESTAMPDIFF(SQL_TSI_DAY, > jiraissue_sub.CREATED, > jiraissue_sub.RESOLUTIONDATE)) > AS CalculatedField > FROM jiraissue jiraissue_sub > GROUP BY jiraissue_sub.issuetype > ORDER BY AVG( > TIMESTAMPDIFF(SQL_TSI_DAY, > jiraissue_sub.CREATED, > jiraissue_sub.RESOLUTIONDATE)) ASC > LIMIT 2) j_Sub > ON jiraissue.issuetype = j_Sub.jiraissue_issuetype > > i verified the query sent to the JDBC [JDBCQueryExecution.java] > SELECT g_0.issuetype > FROM JIRADB.dbo.jiraissue g_0 > LEFT OUTER JOIN ( > SELECT TOP 2 g_1.issuetype AS c_0 > FROM JIRADB.dbo.jiraissue g_1 > GROUP BY g_1.issuetype > ORDER BY anon_grp0.agg0 > ) v_0 > ON g_0.issuetype = v_0.c_0 > > i got the following exception : > > java.sql.SQLException: The multi-part identifier "anon_grp0.agg0" could not be bound -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3118) Excel translator is not able to manage WHERE clause with time value

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3118?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-3118: ----------------------------------- Assignee: Ramesh Reddy > Excel translator is not able to manage WHERE clause with time value > ------------------------------------------------------------------- > > Key: TEIID-3118 > URL: https://issues.jboss.org/browse/TEIID-3118 > Project: Teiid > Issue Type: Bug > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3115) Invalid Query With OrderBy in SubQuery Table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3115?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3115. ----------------------------------- Labels: (was: queryengine) Fix Version/s: 8.9 (was: 8.8) Resolution: Done The output element assignment was only considering adding current unrelated symbols, not order by items that were made unrelated by projection minimization. > Invalid Query With OrderBy in SubQuery Table > -------------------------------------------- > > Key: TEIID-3115 > URL: https://issues.jboss.org/browse/TEIID-3115 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.8 > Reporter: Joseph CHIDIAC > Assignee: Steven Hawkins > Fix For: 8.9 > > > Hi, I'm using Teiid Embedded Server , i tried to execute the Following query : > > SELECT jiraissue.issuetype > FROM imOrganizationjiraissue jiraissue > LEFT OUTER JOIN > (SELECT jiraissue_sub.issuetype AS jiraissue_issuetype, > AVG( > TIMESTAMPDIFF(SQL_TSI_DAY, > jiraissue_sub.CREATED, > jiraissue_sub.RESOLUTIONDATE)) > AS CalculatedField > FROM jiraissue jiraissue_sub > GROUP BY jiraissue_sub.issuetype > ORDER BY AVG( > TIMESTAMPDIFF(SQL_TSI_DAY, > jiraissue_sub.CREATED, > jiraissue_sub.RESOLUTIONDATE)) ASC > LIMIT 2) j_Sub > ON jiraissue.issuetype = j_Sub.jiraissue_issuetype > > i verified the query sent to the JDBC [JDBCQueryExecution.java] > SELECT g_0.issuetype > FROM JIRADB.dbo.jiraissue g_0 > LEFT OUTER JOIN ( > SELECT TOP 2 g_1.issuetype AS c_0 > FROM JIRADB.dbo.jiraissue g_1 > GROUP BY g_1.issuetype > ORDER BY anon_grp0.agg0 > ) v_0 > ON g_0.issuetype = v_0.c_0 > > i got the following exception : > > java.sql.SQLException: The multi-part identifier "anon_grp0.agg0" could not be bound -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3118) Excel translator is not able to manage WHERE clause with time value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3118?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3118: ---------------------------------- Assignee: (was: Steven Hawkins) > Excel translator is not able to manage WHERE clause with time value > ------------------------------------------------------------------- > > Key: TEIID-3118 > URL: https://issues.jboss.org/browse/TEIID-3118 > Project: Teiid > Issue Type: Bug > Reporter: Juraj Duráni > > Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3118) Excel translator is not able to manage WHERE clause with time value

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3118?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3118: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1138715 > Excel translator is not able to manage WHERE clause with time value > ------------------------------------------------------------------- > > Key: TEIID-3118 > URL: https://issues.jboss.org/browse/TEIID-3118 > Project: Teiid > Issue Type: Bug > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3118) Excel translator is not able to manage WHERE clause with time value

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3118: ----------------------------------- Summary: Excel translator is not able to manage WHERE clause with time value Key: TEIID-3118 URL: https://issues.jboss.org/browse/TEIID-3118 Project: Teiid Issue Type: Bug Reporter: Juraj Duráni Assignee: Steven Hawkins Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3116) Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3116: --------------------------------------- That's because the features were not directly connected, but of course can be updated to include a note. Unfortunately given the lack of specificity in how partial results operates you can get different partial results depending upon the capabilities as it can make a difference how much of the query is pushed to the source. > Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked) > ------------------------------------------------------------------------------------------- > > Key: TEIID-3116 > URL: https://issues.jboss.org/browse/TEIID-3116 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Critical > > Description of problem: > Querying a vdb-table which is formed as union of two tables from different datasources. Even though "set partialresultsmode true" is run as initial query, instead of retreiving 0 rows from a datasources that is down, exception is promoted. > Version-Release number of selected component (if applicable): > DV 6.1 ER1 > How reproducible: > Every time > Steps to Reproduce: > 1. Define one valid and one invalid datasource(invalid connection-url). > 2. Create vdb which maps tables from both datasources. > 3. Set partialresultsmode to true > 4. Execute query on the given vdb-table > Actual results: > TeiidSQLException > TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for ORBQT were not avaialable. The command could not be planned properly. > Expected results: > 0 rows from invalid datasource. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3116) Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3116: ------------------------------------ I'm looking at the doc's: https://docs.jboss.org/author/display/TEIID/Partial+Results+Mode and there's nothing mentioned about having to the database version in order for partial results behavior to work. > Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked) > ------------------------------------------------------------------------------------------- > > Key: TEIID-3116 > URL: https://issues.jboss.org/browse/TEIID-3116 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Critical > > Description of problem: > Querying a vdb-table which is formed as union of two tables from different datasources. Even though "set partialresultsmode true" is run as initial query, instead of retreiving 0 rows from a datasources that is down, exception is promoted. > Version-Release number of selected component (if applicable): > DV 6.1 ER1 > How reproducible: > Every time > Steps to Reproduce: > 1. Define one valid and one invalid datasource(invalid connection-url). > 2. Create vdb which maps tables from both datasources. > 3. Set partialresultsmode to true > 4. Execute query on the given vdb-table > Actual results: > TeiidSQLException > TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for ORBQT were not avaialable. The command could not be planned properly. > Expected results: > 0 rows from invalid datasource. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3117) NullPointerException while creating source model from Excel table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3117?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3117: ---------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) Seems related to TEIID-3026 but is happening on getting the cell type. > NullPointerException while creating source model from Excel table > ----------------------------------------------------------------- > > Key: TEIID-3117 > URL: https://issues.jboss.org/browse/TEIID-3117 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Environment: Fedora 20, data virtualization 6.1.0.ER1 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Attachments: ExcelDynamic-vdb.xml, Server.log, smalla.xlsx, smalla_raw.xlsx > > > I am trying to create source model from Excel file (.xlsx). When I set property "Header Row Number" to 1 (using Teiid Designer), creating ends with NullPointerException. Setting "Header Row Number" to 0 executes with no problems. > Same problem (and same exception) with dynamic VDB (only with <property name="importer.headerRowNumber" value="1"/>). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3117) NullPointerException while creating source model from Excel table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3117?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3117: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1138697 > NullPointerException while creating source model from Excel table > ----------------------------------------------------------------- > > Key: TEIID-3117 > URL: https://issues.jboss.org/browse/TEIID-3117 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Environment: Fedora 20, data virtualization 6.1.0.ER1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: ExcelDynamic-vdb.xml, Server.log, smalla.xlsx, smalla_raw.xlsx > > > I am trying to create source model from Excel file (.xlsx). When I set property "Header Row Number" to 1 (using Teiid Designer), creating ends with NullPointerException. Setting "Header Row Number" to 0 executes with no problems. > Same problem (and same exception) with dynamic VDB (only with <property name="importer.headerRowNumber" value="1"/>). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 4 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2014