September 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2644) Support retrieving result sets from any out parameter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2644?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2644. --------------------------------- > Support retrieving result sets from any out parameter > ----------------------------------------------------- > > Key: TEIID-2644 > URL: https://issues.jboss.org/browse/TEIID-2644 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > Currently Teiid expects the driver (for example DataDirect) or in case of oracle the return parameter to be result set. In scenarios were a wrapping stored function cannot be created we should also offer support for retrieving any out parameter as the result set. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2614) Allow anonymous procedure blocks

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2614?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2614. --------------------------------- > Allow anonymous procedure blocks > -------------------------------- > > Key: TEIID-2614 > URL: https://issues.jboss.org/browse/TEIID-2614 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.5 > > > In some cases it is beneficial to submit a block of sql for processing rather than performing partial result processing in the client. > Given that we are effectively using anon blocks internally, we should expose this feature for general use. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2626) If a column type is not set, null values will be written into persisted batches

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2626?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2626. --------------------------------- > If a column type is not set, null values will be written into persisted batches > ------------------------------------------------------------------------------- > > Key: TEIID-2626 > URL: https://issues.jboss.org/browse/TEIID-2626 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.5 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.4.1, 8.5 > > > The buffer manager will choose the null serializer if a column type is not set. This is not expected to happen, but test code can be sloppy which isn't evident if the weak reference cache is working effectively. > However there is one place in the code that is effected, which is the internally generated partitionId column on any window function expression with a non-empty over clause. This means that on systems with limited memory and or poor performing weak references no results for the window function may be returned. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1892) Support the get/setArray methods of JDBC resultsets/statements

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1892?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1892. --------------------------------- > Support the get/setArray methods of JDBC resultsets/statements > -------------------------------------------------------------- > > Key: TEIID-1892 > URL: https://issues.jboss.org/browse/TEIID-1892 > Project: Teiid > Issue Type: Sub-task > Components: JDBC Driver > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.5 > > > We'd like the array related JDBC methods supported. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2621) improve texttable error messages

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2621?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2621. --------------------------------- > improve texttable error messages > -------------------------------- > > Key: TEIID-2621 > URL: https://issues.jboss.org/browse/TEIID-2621 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > Not all exceptions from texttable report the line number. Additionally we should be consistent about reporting a 1 based line number and a column number would be useful as well. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2632) Atomic blocks don't reset the transaction context on completion

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2632?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2632. --------------------------------- > Atomic blocks don't reset the transaction context on completion > --------------------------------------------------------------- > > Key: TEIID-2632 > URL: https://issues.jboss.org/browse/TEIID-2632 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.6 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.4.1, 8.5 > > > Once an atomic block has completed the transaction context remains as if it were a request level transaction. Further work, such as adding synchronizations, will result in exceptions as the txn has completed. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2645) Invalid vdb results in NPE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2645?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2645. --------------------------------- > Invalid vdb results in NPE > -------------------------- > > Key: TEIID-2645 > URL: https://issues.jboss.org/browse/TEIID-2645 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.5 > > > If we don't find a vdb.xml file in a vdb we'll later incur an NPE. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2629) Message for missing translator needs improvement

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2629?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2629. --------------------------------- > Message for missing translator needs improvement > ------------------------------------------------ > > Key: TEIID-2629 > URL: https://issues.jboss.org/browse/TEIID-2629 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine, Server > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > If a vdb references a non-existent translator type our message is not helpful - in embedded the exception message is the translator name and in the server we mention the vdb. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2625) Part of join criteria is getting ignored

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2625?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2625. --------------------------------- > Part of join criteria is getting ignored > ---------------------------------------- > > Key: TEIID-2625 > URL: https://issues.jboss.org/browse/TEIID-2625 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7.1 > Environment: z/OS JZOS > Reporter: Jeff Hayes > Assignee: Steven Hawkins > Attachments: 7.7_Teiid_SHOWPLAN > > > The second part of the join criteria (and CHORUS_J0.userid = CHORUS_B.evtuserid) appears to be getting ignored. The result has same results as when only the first criteria (CHORUS_J0.sysid = cx2.sysid) is provided. > Same query works are 8.1 with query plan listing both criteria in joinNode however for 7.7 only shows first criteria. > > Please see attached query plan. > One thing to note is that the same query on 7.7 works when the databases > are on DB2 (using DB2 translator) but not when they are on Datacom (different translator). Is this possibly a translator issue maybe not being able to support multiple join criteria? > 8/15: Confirmed the problem occurs for both DB2 and Datacom translators. > Any advice would be appreciated as this is affected a customer installation. > Thanks! > Jeff > -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2634) Dynamic SQL will fail to execute in an exception handling block

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2634?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2634. --------------------------------- > Dynamic SQL will fail to execute in an exception handling block > --------------------------------------------------------------- > > Key: TEIID-2634 > URL: https://issues.jboss.org/browse/TEIID-2634 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > A dynamic variable statement will convert the current variable context into a substitution map for placement in the command during rewrite. However since there is a value typed as "exception" in the context the correponding constant created will throw what amounts to an assertion error. -- 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

11 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2013