November 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-2069: ------------------------------------ Summary: Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle Key: TEIID-2069 URL: https://issues.jboss.org/browse/TEIID-2069 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7, 7.4.1 Reporter: Johnathon Lee Assignee: Steven Hawkins LIMIT clause is added to Statement being optimized which fails the operation on Oracle OPTIMIZE: CREATE VIRTUAL PROCEDURE BEGIN DECLARE biginteger VARIABLES.t_pk; VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen); SELECT VARIABLES.t_pk AS result; END #################################################### PROCEDURE COMMAND: CREATE VIRTUAL PROCEDURE BEGIN DECLARE biginteger VARIABLES.t_pk; VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen LIMIT 2); SELECT VARIABLES.t_pk AS result; END -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
25
0 / 0

[JBoss JIRA] (TEIID-2295) Quick start to demonstrate how to use Native Query capability

by Van Halbert (JIRA)

Van Halbert created TEIID-2295: ---------------------------------- Summary: Quick start to demonstrate how to use Native Query capability Key: TEIID-2295 URL: https://issues.jboss.org/browse/TEIID-2295 Project: Teiid Issue Type: Sub-task Components: Build/Kits Reporter: Van Halbert Assignee: Steven Hawkins Create a quick start that demonstrates using the Native Query support. -- 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, 1 month

1
3
0 / 0

[JBoss JIRA] (TEIID-2183) Duplicate column exception mentions table instead

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2183: ------------------------------------- Summary: Duplicate column exception mentions table instead Key: TEIID-2183 URL: https://issues.jboss.org/browse/TEIID-2183 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The duplicate column exception from the MetadataFactory mentions table instead. -- 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, 1 month

1
2
0 / 0

[JBoss JIRA] (TEIID-2185) Cost estimation for temp table index selection is incorrect

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2185: ------------------------------------- Summary: Cost estimation for temp table index selection is incorrect Key: TEIID-2185 URL: https://issues.jboss.org/browse/TEIID-2185 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The index selection for temporary tables incorrectly computes an additional cost factor that biases the selection against secondary indexies. -- 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, 1 month

3
6
0 / 0

[JBoss JIRA] (TEIID-2299) Remove examples from jboss kit, they have been converted to quicks starts

by Van Halbert (JIRA)

Van Halbert created TEIID-2299: ---------------------------------- Summary: Remove examples from jboss kit, they have been converted to quicks starts Key: TEIID-2299 URL: https://issues.jboss.org/browse/TEIID-2299 Project: Teiid Issue Type: Task Components: Build/Kits Affects Versions: 8.2 Reporter: Van Halbert Assignee: Van Halbert Fix For: 8.2 The 3 examples in the jboss kit; dynamicvdb-portfolio, dynamicvdb-twitter and simple client, have been converted to quicks starts. Remove these examples from the jboss kit. -- 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, 1 month

2
4
0 / 0

[JBoss JIRA] (TEIID-2272) Add Teiid quickstarts

by Van Halbert (JIRA)

Van Halbert created TEIID-2272: ---------------------------------- Summary: Add Teiid quickstarts Key: TEIID-2272 URL: https://issues.jboss.org/browse/TEIID-2272 Project: Teiid Issue Type: Task Components: Build/Kits Affects Versions: 8.2 Reporter: Van Halbert Assignee: Van Halbert This the parent task for tracking the different quick starts. -- 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, 1 month

2
3
0 / 0

[JBoss JIRA] (TEIID-2234) Function pushdown issues

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2234: ------------------------------------- Summary: Function pushdown issues Key: TEIID-2234 URL: https://issues.jboss.org/browse/TEIID-2234 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 Function validation should not prevent a function name from containing a '.' and nameinsource should be respected for ddl foreign functions. We also have an issue with function names conflicting with system function names any time there is a check of just the descriptor name without checking the schema. -- 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, 1 month

1
3
0 / 0

[JBoss JIRA] (TEIID-2242) Create quick start

by Van Halbert (JIRA)

Van Halbert created TEIID-2242: ---------------------------------- Summary: Create quick start Key: TEIID-2242 URL: https://issues.jboss.org/browse/TEIID-2242 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 8.2 Reporter: Van Halbert Assignee: Van Halbert Create a quickstart demonstrating the ability to query infinispan using a local cache. -- 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, 1 month

2
7
0 / 0

[JBoss JIRA] (TEIID-2190) Key usage can remove predicates

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2190: ------------------------------------- Summary: Key usage can remove predicates Key: TEIID-2190 URL: https://issues.jboss.org/browse/TEIID-2190 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 8.2 The implementation strategy for predicate realignment can drop non-column equi join predicates and predicates involving the same column reused multiple times. i.e. create local temporary table x (e1 string, e2 integer, primary key (e1)); create local temporary table x1 (e1 string, e2 integer) ... select x.e1 from x inner join x1 on x.e1 = x1.e1 and upper(x.e1) = x1.e2 May end up not applying the upper predicate. -- 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, 1 month

2
5
0 / 0

[JBoss JIRA] (TEIID-2271) Timing issue when processing data from an XML stream

by Paul Richardson (JIRA)

Paul Richardson created TEIID-2271: -------------------------------------- Summary: Timing issue when processing data from an XML stream Key: TEIID-2271 URL: https://issues.jboss.org/browse/TEIID-2271 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 8.2 Reporter: Paul Richardson Assignee: Steven Hawkins Running a preview on an XML datasource causes a freezing of the gui. The main thread is stuck trying {{SocketInputStream.socketRead0}}, which never returns. The jboss log indicates a BlockedException has occurred and only when designer is forcibly terminated does the input stream read get cancelled. Discussions over the log indicate ... '... a timing issue where the asynch processing thread notifies after the processing thread has been detached and there's no other action that restarts the plan' Server log snippet attached. -- 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, 1 month

2
3
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2012