June 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2345) source hints are not honoured for nested sqls

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2345?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2345. --------------------------------- > source hints are not honoured for nested sqls > --------------------------------------------- > > Key: TEIID-2345 > URL: https://issues.jboss.org/browse/TEIID-2345 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > > Hi > I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. As per this document https://docs.jboss.org/author/display/TEIID/Query+Plans if i use KEEP_ALIASES general hint is available for all nested queries but i was not able to get it working > SELECT /*+ sh[KEEP ALIASES]:'foo' bar:'leading' */ \r\n" when i use something like this general hint is null in all the executions. > If i use below general hint is available only to the first execution. > "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" > + " chorus_results.* \r\n" > + "FROM (\r\n" > + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" > + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2361) The current MAX String size is 4000, add the ability to configure when larger sizes are used

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2361?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2361. --------------------------------- > The current MAX String size is 4000, add the ability to configure when larger sizes are used > -------------------------------------------------------------------------------------------- > > Key: TEIID-2361 > URL: https://issues.jboss.org/browse/TEIID-2361 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.3, 7.7.7 > > > The MAX String size is currently 4000. After a discussion with Steve, he indicated a more common default might be 16k, and also add the ability to configure the size when a data source is being used that contains large sizes. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1092) Request to have Global Variables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1092?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1092. --------------------------------- > Request to have Global Variables > -------------------------------- > > Key: TEIID-1092 > URL: https://issues.jboss.org/browse/TEIID-1092 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.4 > > > Customer is requesting a Global Variable. They want the variable to persist outside of one procedure to other spawned procedures and subsequent queries. -- 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, 10 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 closed TEIID-2482. --------------------------------- > 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, 7.7.7 > > > 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2373) Strict LIMITs are not properly enforced

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2373?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2373. --------------------------------- > Strict LIMITs are not properly enforced > --------------------------------------- > > Key: TEIID-2373 > URL: https://issues.jboss.org/browse/TEIID-2373 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.6 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > The notion of a strict limit introduced by TEIID-1806 - is not strictly enforced when an unordered limit is first pushed across a union. The result may be fewer rows than expected if the limit is then pushed across a select node. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2179) User defined aggregate function return type is ignored

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2179?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2179. --------------------------------- > User defined aggregate function return type is ignored > ------------------------------------------------------ > > Key: TEIID-2179 > URL: https://issues.jboss.org/browse/TEIID-2179 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.2 > > > The resolver is using the type of the first argument rather than the declared return type. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2455) Cannot execute SQL query using SQL function in SORT clause via view model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2455?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2455. --------------------------------- > Cannot execute SQL query using SQL function in SORT clause via view model > ------------------------------------------------------------------------- > > Key: TEIID-2455 > URL: https://issues.jboss.org/browse/TEIID-2455 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.4, 7.7.7 > > > If SQL query is contained using SQL function in SORT clause, the query cannot execute via view model. > ex) SELECT C1 FROM TEST_TABLE_VW order by CAST(C3 AS integer) > Version-Release number of selected component (if applicable): > EDS 5.3.1 -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2515) org.teiid.resource javadocs missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2515?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2515. --------------------------------- > org.teiid.resource javadocs missing > ----------------------------------- > > Key: TEIID-2515 > URL: https://issues.jboss.org/browse/TEIID-2515 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Affects Versions: 7.4.1, 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > TEIID-1752 accidentally excluded org.teiid.resource -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2478) incomplete with pushdown

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2478?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2478. --------------------------------- > incomplete with pushdown > ------------------------ > > Key: TEIID-2478 > URL: https://issues.jboss.org/browse/TEIID-2478 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4, 7.7.7 > > > If all the with clauses are not fully pushed, but is still pushable, the resulting query plan will contain incomplete references to the clauses. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2354) Inherent insert using WHERE partitioning is incomplete

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2354?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2354. --------------------------------- > Inherent insert using WHERE partitioning is incomplete > ------------------------------------------------------ > > Key: TEIID-2354 > URL: https://issues.jboss.org/browse/TEIID-2354 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > Using a metadata structure such as: > create foreign table b (custid integer, field1 varchar) options updatable true) > create view c options (updatable true) as select * from b where custid = 1 union all select * from b where custid = 2; > will fail to process INSERT into c (custid, field1) values (1, 'foo') > because a null value will be inserted into be for the custid field. The logic is treating the WHERE partitioning as if it were projected literals from the SELECT cause inappropriately. -- 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, 10 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 June 2013