August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1353928|https://bugzilla.redhat.com/show_bug.cgi?id=1353928] from ON_QA to VERIFIED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4278. --------------------------------- > 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, 8.7.8.6_2 > > > 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, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4304) Correct handling with subquery in on clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4304?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4304. --------------------------------- > Correct handling with subquery in on clause > ------------------------------------------- > > Key: TEIID-4304 > URL: https://issues.jboss.org/browse/TEIID-4304 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.1, 8.7.8.6_2, 9.0.2 > > > With the translator capability supportsSubqueryInOn false, we can still plan a query with a subquery in the on clause if non-join criteria on the inner side of a left outer join is used in the user query on clause (it is temporarily pushed out of the join and then added back in rule collapse source). > Additionally the oracle translator should not support subquery in on for oracle 11 and earlier. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4330) Better planning with chained makedep scenarios

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4330?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4330. --------------------------------- > Better planning with chained makedep scenarios > ---------------------------------------------- > > Key: TEIID-4330 > URL: https://issues.jboss.org/browse/TEIID-4330 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Plans with an implied series of make dep may not have the hint honored as intended. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3866) with clause used by subquery repeated in the subquery

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3866?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3866. --------------------------------- > with clause used by subquery repeated in the subquery > ----------------------------------------------------- > > Key: TEIID-3866 > URL: https://issues.jboss.org/browse/TEIID-3866 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4, 8.7.8.6_2 > > > A query such as: > with eee as (select * from pm1.g1) select * from pm1.g2 where pm1.g2.e1 in (select e1 from eee) > will result in a push down that repeats the with clause in the subquery: > ... (with eee ... select e1 from eee) > It is sufficient to rely on the parent to define the common table. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 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 commented on TEIID-4278: ------------------------------------------------ Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1349560|https://bugzilla.redhat.com/show_bug.cgi?id=1349560] from ON_QA to VERIFIED > 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, 8.7.8.6_2 > > > 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, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4384) Issue with ordered offset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4384?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4384. ----------------------------------- Fix Version/s: 9.1 9.0.3 Resolution: Done Corrected the limit node to only specify the limit to the sort when a limit is present. > Issue with ordered offset > ------------------------- > > Key: TEIID-4384 > URL: https://issues.jboss.org/browse/TEIID-4384 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.1, 9.0.3 > > > There is a regression with TEIID-4210 such that when an order by is not pushed and there is a parent offset (no limit), the wrong rows are returned. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4384) Issue with ordered offset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4384?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4384: ---------------------------------- Priority: Critical (was: Major) > Issue with ordered offset > ------------------------- > > Key: TEIID-4384 > URL: https://issues.jboss.org/browse/TEIID-4384 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > > There is a regression with TEIID-4210 such that when an order by is not pushed and there is a parent offset (no limit), the wrong rows are returned. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4210) Allow limits to apply to the final sort pass

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4210?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4210. ----------------------------------- Resolution: Done This introduced a critical regression - TEIID-4384 > Allow limits to apply to the final sort pass > -------------------------------------------- > > Key: TEIID-4210 > URL: https://issues.jboss.org/browse/TEIID-4210 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > A left over todo was to support allowing the affect of limiting to short circuit the last sort phase. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4384) Issue with ordered offset

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4384: ------------------------------------- Summary: Issue with ordered offset Key: TEIID-4384 URL: https://issues.jboss.org/browse/TEIID-4384 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins There is a regression with TEIID-4210 such that when an order by is not pushed and there is a parent offset (no limit), the wrong rows are returned. -- 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