May 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2453) Add a string_agg or similarly named aggregate for creating a delimited concat

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2453?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2453. ----------------------------------- Resolution: Done Added a string_agg aggregate matching the pgsql functionality - only the pg translator was marked as supporting the function. Updated the release notes and the reference as well. > Add a string_agg or similarly named aggregate for creating a delimited concat > ----------------------------------------------------------------------------- > > Key: TEIID-2453 > URL: https://issues.jboss.org/browse/TEIID-2453 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > Similar to the pg string_agg (which supports blob/clob) delimited concat, we should offer a built-in aggregate. There is similar support on oracle 11g+ and mysql. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2482) Allow the use of the enhanced join for left outer joins

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2482?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2482: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=961097 > Allow the use of the enhanced join for left outer joins > ------------------------------------------------------- > > Key: TEIID-2482 > URL: https://issues.jboss.org/browse/TEIID-2482 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > Left equi outer joins are currently only implemented using the full sort merge join and would benefit from using the enhanced merge when the inner side is relatively small. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2482) Allow the use of the enhanced join for left outer joins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2482?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2482: --------------------------------------- The second commits gives the planner more flexibility to not push down sorts that it believes will not be necessary. The only drawback to this optimization is that there is no hint to override the behavior should a pushdown sort be needed. This commit is currently not needed for backporting. > Allow the use of the enhanced join for left outer joins > ------------------------------------------------------- > > Key: TEIID-2482 > URL: https://issues.jboss.org/browse/TEIID-2482 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > Left equi outer joins are currently only implemented using the full sort merge join and would benefit from using the enhanced merge when the inner side is relatively small. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2209) Temp logic should support the array type

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2209?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2209. ----------------------------------- Resolution: Done Added the array type capability and the index logic to utilize array comparisons. > Temp logic should support the array type > ---------------------------------------- > > Key: TEIID-2209 > URL: https://issues.jboss.org/browse/TEIID-2209 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.4 > > > If a temp table is made the dependent side of a multi-column dependent join, the index logic should support the array type for more efficient processing. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2485) Remove the resteasy patch thats no longer needed in EAP 6.1 ER5

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2485?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2485: ---------------------------------- Fix Version/s: 8.4.1 (was: 8.4) > Remove the resteasy patch thats no longer needed in EAP 6.1 ER5 > --------------------------------------------------------------- > > Key: TEIID-2485 > URL: https://issues.jboss.org/browse/TEIID-2485 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.4.1 > > > The resteasy patch thats provided in the kit is no longer needed. As of EAP 6.1 ER5, resteasy has been upgraded to 2.3.6, and resolves RESTEASY-812 issue. > I have verified the fix and have several EAP 6.1 ER5 servers running with Teiid 8.4 alpha without the patch applied. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2486) Standalone CLI script has a small required change to work with EAP 6.1

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2486?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2486. ----------------------------------- Resolution: Done Confirmed the fix is fine for 8.4 with Ramesh. > Standalone CLI script has a small required change to work with EAP 6.1 > ---------------------------------------------------------------------- > > Key: TEIID-2486 > URL: https://issues.jboss.org/browse/TEIID-2486 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.4 > > > The following command doesn't support the "name" attribute: > /subsystem=threads/bounded-queue-thread-pool=teiid-async:add(name=teiid-async, max-threads=4, queue-length=100) > This is the same issue seen in the domain script. So the command should be changed to be: > /subsystem=threads/bounded-queue-thread-pool=teiid-async:add(max-threads=4, queue-length=100) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2498) Insert with simple select ? fails

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2498?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2498. ----------------------------------- Resolution: Done Allowed for implicit resolving of untyped references when using a query expression. > Insert with simple select ? fails > --------------------------------- > > Key: TEIID-2498 > URL: https://issues.jboss.org/browse/TEIID-2498 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.4 > > > A query such as > Insert Into TableA( col1, col2 ) Select ?, ? > will fail as we are not expecting to implicitly resolve references in an insert query expression. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2498) Insert with simple select ? fails

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2498: ------------------------------------- Summary: Insert with simple select ? fails Key: TEIID-2498 URL: https://issues.jboss.org/browse/TEIID-2498 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.4 A query such as Insert Into TableA( col1, col2 ) Select ?, ? will fail as we are not expecting to implicitly resolve references in an insert query expression. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2497) Add support for DECODE(column, column_value, column_to_replace_with)

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2497?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2497: ------------------------------------ The following worked: Select IntKey, SUM(CASE StringKey WHEN '11' THEN IntNum END) As NewColumnA, SUM(CASE StringKey WHEN '12' THEN IntNum END) As NewColumnB, SUM(CASE StringKey WHEN '13' THEN IntNum END) As NewColumnC FROM BQT1.SmallA Group By IntKey I assume you can close this feature request as being satisfied. > Add support for DECODE(column, column_value, column_to_replace_with) > -------------------------------------------------------------------- > > Key: TEIID-2497 > URL: https://issues.jboss.org/browse/TEIID-2497 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.6 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Looking at pivot and trying to use it like: > Select salesperson, SUM(DECODE(product, 'CarA', amount)) as ProductCarA, > SUM(DECODE(product, 'CarB', amount)) as ProductCarB, > SUM(DECODE(product, 'CarC', amount)) as ProductCarC > From SALES > Group By salesperson > Teiid's Decode requires you to know the value to substitute, with this option, it can be dynamically substituted at run time. > > See: http://www.clearpeaks.com/blog/data-warehousing/pivot-data-in-sql -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2497) Add support for DECODE(column, column_value, column_to_replace_with)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2497?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2497. ----------------------------------- Resolution: Rejected DECODE is just a short cut for a case expression DECODE(product, 'CarB', amount) can be expressed as: CASE product WHEN 'CarB' THEN amount END > Add support for DECODE(column, column_value, column_to_replace_with) > -------------------------------------------------------------------- > > Key: TEIID-2497 > URL: https://issues.jboss.org/browse/TEIID-2497 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.6 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Looking at pivot and trying to use it like: > Select salesperson, SUM(DECODE(product, 'CarA', amount)) as ProductCarA, > SUM(DECODE(product, 'CarB', amount)) as ProductCarB, > SUM(DECODE(product, 'CarC', amount)) as ProductCarC > From SALES > Group By salesperson > Teiid's Decode requires you to know the value to substitute, with this option, it can be dynamically substituted at run time. > > See: http://www.clearpeaks.com/blog/data-warehousing/pivot-data-in-sql -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 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 May 2013