May 2013 - teiid-issues - Jboss List Archives

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

by Van Halbert (JIRA)

Van Halbert created TEIID-2497: ---------------------------------- Summary: 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2249: ---------------------------------- Fix Version/s: 8.4.1 (was: 8.4) > Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS > ---------------------------------------------------------------------------------------------------------- > > Key: TEIID-2249 > URL: https://issues.jboss.org/browse/TEIID-2249 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.4.1 > > > Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead. > One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server. -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2369) Query plan for continuous execution should be refreshed after alter command

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2369?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2369. ----------------------------------- Resolution: Done Added plan validation to the continuous execution loop. > Query plan for continuous execution should be refreshed after alter command > --------------------------------------------------------------------------- > > Key: TEIID-2369 > URL: https://issues.jboss.org/browse/TEIID-2369 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.1 > Environment: Windows > Reporter: Sanjeev Gour > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.4 > > > When continuous queries are started on a view and the view is later altered, the change in the view definition is picked up. This is due to the query plan being cached at the time of initial execution. Following discussion contains more information- > https://community.jboss.org/thread/220761 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2491) ODBC ScriptReader workarounds do not handle EOF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2491?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2491: --------------------------------------- Also changed the logic to use casts for string literals as that is the syntax produced by the common escapes {d '..., {t '..., etc. Otherwise the next level of fix would be to move the :: cast support into the parser. > ODBC ScriptReader workarounds do not handle EOF > ----------------------------------------------- > > Key: TEIID-2491 > URL: https://issues.jboss.org/browse/TEIID-2491 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > Issuing a query such as select 'foo'::bar > will result in an error since the workaround to drop the ::bar appends the EOF to the sql text. -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2496) "Object is already closed" error when reading CLOB from H2 in Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2496?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2496. ----------------------------------- Resolution: Done Addressed with a better type check in the data tier tuple source and also ensure that lob inlining happens proactively. It may be good to add yet another tracking mode so that the inlining can be performed more lazily (either on demand when the batch is persisted or when processing is finished and the request wants to detach the lobs). > "Object is already closed" error when reading CLOB from H2 in Teiid > ------------------------------------------------------------------- > > Key: TEIID-2496 > URL: https://issues.jboss.org/browse/TEIID-2496 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7.1 > Environment: Teiid 8.1, java version "1.7.0_09", Win 7, JBoss 7.0.1 > Reporter: Andriy Rokhmanov > Assignee: Steven Hawkins > Fix For: 8.4 > > Attachments: EmbeddedTest.java, EmbeddedTestError.txt > > > I am getting "The object is already closed [90007-168]" exception when attempt to read table with CLOB column in Teiid. > For more details see attached sample unit test case (Embedded Teiid) and a complete exception dump. > See discussion at https://community.jboss.org/thread/227854?tstart=0 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2496) "Object is already closed" error when reading CLOB from H2 in Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2496?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2496: ---------------------------------- Workaround Description: Enable copyLobs on the translator where the lob originates from. Workaround: Workaround Exists > "Object is already closed" error when reading CLOB from H2 in Teiid > ------------------------------------------------------------------- > > Key: TEIID-2496 > URL: https://issues.jboss.org/browse/TEIID-2496 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7.1 > Environment: Teiid 8.1, java version "1.7.0_09", Win 7, JBoss 7.0.1 > Reporter: Andriy Rokhmanov > Assignee: Steven Hawkins > Fix For: 8.4 > > Attachments: EmbeddedTest.java, EmbeddedTestError.txt > > > I am getting "The object is already closed [90007-168]" exception when attempt to read table with CLOB column in Teiid. > For more details see attached sample unit test case (Embedded Teiid) and a complete exception dump. > See discussion at https://community.jboss.org/thread/227854?tstart=0 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2496) "Object is already closed" error when reading CLOB from H2 in Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2496?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2496: ---------------------------------- Fix Version/s: 8.4 Affects Version/s: 7.7.1 Component/s: Query Engine > "Object is already closed" error when reading CLOB from H2 in Teiid > ------------------------------------------------------------------- > > Key: TEIID-2496 > URL: https://issues.jboss.org/browse/TEIID-2496 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7.1 > Environment: Teiid 8.1, java version "1.7.0_09", Win 7, JBoss 7.0.1 > Reporter: Andriy Rokhmanov > Assignee: Steven Hawkins > Fix For: 8.4 > > Attachments: EmbeddedTest.java, EmbeddedTestError.txt > > > I am getting "The object is already closed [90007-168]" exception when attempt to read table with CLOB column in Teiid. > For more details see attached sample unit test case (Embedded Teiid) and a complete exception dump. > See discussion at https://community.jboss.org/thread/227854?tstart=0 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2496) "Object is already closed" error when reading CLOB from H2 in Teiid

by Andriy Rokhmanov (JIRA)

Andriy Rokhmanov created TEIID-2496: --------------------------------------- Summary: "Object is already closed" error when reading CLOB from H2 in Teiid Key: TEIID-2496 URL: https://issues.jboss.org/browse/TEIID-2496 Project: Teiid Issue Type: Bug Environment: Teiid 8.1, java version "1.7.0_09", Win 7, JBoss 7.0.1 Reporter: Andriy Rokhmanov Assignee: Steven Hawkins Attachments: EmbeddedTest.java, EmbeddedTestError.txt I am getting "The object is already closed [90007-168]" exception when attempt to read table with CLOB column in Teiid. For more details see attached sample unit test case (Embedded Teiid) and a complete exception dump. See discussion at https://community.jboss.org/thread/227854?tstart=0 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2496) "Object is already closed" error when reading CLOB from H2 in Teiid

by Andriy Rokhmanov (JIRA)

[ https://issues.jboss.org/browse/TEIID-2496?page=com.atlassian.jira.plugin... ] Andriy Rokhmanov updated TEIID-2496: ------------------------------------ Attachment: EmbeddedTest.java EmbeddedTestError.txt > "Object is already closed" error when reading CLOB from H2 in Teiid > ------------------------------------------------------------------- > > Key: TEIID-2496 > URL: https://issues.jboss.org/browse/TEIID-2496 > Project: Teiid > Issue Type: Bug > Environment: Teiid 8.1, java version "1.7.0_09", Win 7, JBoss 7.0.1 > Reporter: Andriy Rokhmanov > Assignee: Steven Hawkins > Attachments: EmbeddedTest.java, EmbeddedTestError.txt > > > I am getting "The object is already closed [90007-168]" exception when attempt to read table with CLOB column in Teiid. > For more details see attached sample unit test case (Embedded Teiid) and a complete exception dump. > See discussion at https://community.jboss.org/thread/227854?tstart=0 -- 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2495) Detect situations in which intermediate updates are not needed such that the updates can be grouped

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2495?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2495: ---------------------------------- Component/s: Query Engine (was: Common) > Detect situations in which intermediate updates are not needed such that the updates can be grouped > --------------------------------------------------------------------------------------------------- > > Key: TEIID-2495 > URL: https://issues.jboss.org/browse/TEIID-2495 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.3 > Reporter: Jing Li > Assignee: Steven Hawkins > > The default processing model is to simply perform the execution for each row, an enhancment would be required for Teiid to detect situations in which intermediate updates are not needed such that the updates can be grouped. -- 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, 8 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