May 2013 - teiid-issues - Jboss List Archives

[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: ---------------------------------- Fix Version/s: (was: 8.4) Priority: Major (was: Critical) > 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: Common > 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

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

by Jing Li (JIRA)

Jing Li created TEIID-2495: ------------------------------ Summary: 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: Common Affects Versions: 8.3 Reporter: Jing Li Assignee: Steven Hawkins Priority: Critical Fix For: 8.4 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

[JBoss JIRA] (TEIID-2494) View definition column naming issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2494?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2494: ---------------------------------- Affects Version/s: 8.0 (was: 7.7) > View definition column naming issue > ----------------------------------- > > Key: TEIID-2494 > URL: https://issues.jboss.org/browse/TEIID-2494 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. > for example: > SELECT MIN(x.count) FROM agg x > will fail with agg defined as > create foreign table smalla (intkey integer); > create view agg (count integer) as select count(\*) from smalla; > but will function correctly with count(\*) as count > -- 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-2494) View definition column naming issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2494?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2494. ----------------------------------- Resolution: Done Corrected the projected view columns when the inline view is initially created. > View definition column naming issue > ----------------------------------- > > Key: TEIID-2494 > URL: https://issues.jboss.org/browse/TEIID-2494 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. > for example: > SELECT MIN(x.count) FROM agg x > will fail with agg defined as > create foreign table smalla (intkey integer); > create view agg (count integer) as select count(\*) from smalla; > but will function correctly with count(\*) as count > -- 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-2494) View definition column naming issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2494?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2494: ---------------------------------- Summary: View definition column naming issue (was: Non-matching) Description: View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. for example: SELECT MIN(x.count) FROM agg x will fail with agg defined as create foreign table smalla (intkey integer); create view agg (count integer) as select count(\*) from smalla; but will function correctly with count(\*) as count was:View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. > View definition column naming issue > ----------------------------------- > > Key: TEIID-2494 > URL: https://issues.jboss.org/browse/TEIID-2494 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. > for example: > SELECT MIN(x.count) FROM agg x > will fail with agg defined as > create foreign table smalla (intkey integer); > create view agg (count integer) as select count(\*) from smalla; > but will function correctly with count(\*) as count > -- 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-2494) Non-matching

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2494: ------------------------------------- Summary: Non-matching Key: TEIID-2494 URL: https://issues.jboss.org/browse/TEIID-2494 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.4 View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down. -- 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-2493) SQLServer prepared clob fails

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2493?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2493. ----------------------------------- Resolution: Done Used the set lobs as streams override for sql server and added an automatic check to see if the jtds driver is in use. > SQLServer prepared clob fails > ----------------------------- > > Key: TEIID-2493 > URL: https://issues.jboss.org/browse/TEIID-2493 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > The use of the setObject(pos, object, type) method against the MS 4.0 SQLServer driver causes a check that prevents the usage of our ClobType that since TEIID-2100 has also been an NClob. > The setClob and even setObject without the type methods all work without an issue. -- 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-2493) SQLServer prepared clob fails

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2493: ------------------------------------- Summary: SQLServer prepared clob fails Key: TEIID-2493 URL: https://issues.jboss.org/browse/TEIID-2493 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.4 The use of the setObject(pos, object, type) method against the MS 4.0 SQLServer driver causes a check that prevents the usage of our ClobType that since TEIID-2100 has also been an NClob. The setClob and even setObject without the type methods all work without an issue. -- 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-2492) AssertionError from aliased unrelated order by item

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2492?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2492. ----------------------------------- Resolution: Done This was only an issue for push-down order by as the engine ordering logic would handle the aliased symbol, so the fix was just to have the alias generator strip aliasing from unrelated order by items. > AssertionError from aliased unrelated order by item > --------------------------------------------------- > > Key: TEIID-2492 > URL: https://issues.jboss.org/browse/TEIID-2492 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4 > > > The planning logic leaves alias symbols in the order by clause for unrelated items, which causes an assertion error when creating the translator command. -- 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-2492) AssertionError from aliased unrelated order by item

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2492: ------------------------------------- Summary: AssertionError from aliased unrelated order by item Key: TEIID-2492 URL: https://issues.jboss.org/browse/TEIID-2492 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.4 The planning logic leaves alias symbols in the order by clause for unrelated items, which causes an assertion error when creating the translator command. -- 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