November 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1265) Document the replacement approach for credentail maps

by Steven Hawkins (JIRA)

Document the replacement approach for credentail maps ----------------------------------------------------- Key: TEIID-1265 URL: https://jira.jboss.org/browse/TEIID-1265 Project: Teiid Issue Type: Quality Risk Components: Misc. Connectors Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1 The client based credential map feature was removed from the project. There should be a replacement approach documented for JBossAS where source connections can have more than 1 set of static credentials with appropriate pooling. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1370) Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query - But query is valid

by Paul Nittel (JIRA)

Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query - But query is valid ------------------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-1370 URL: https://jira.jboss.org/browse/TEIID-1370 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Environment: Fedora 12, OpenJDK Server VM (build 14.0-b16), SOA-P 5.1 ER4 Reporter: Paul Nittel Assignee: Steven Hawkins I ran into this executing the E2E TPCR Text Metadata Test Script and it can be reproduced by focusing on query #22. A model project set and other necessary artifacts will be attached. The whole error, from SQuirreL, is: Error: Error Code:107 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:107 Message:Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0] The executed query is: select * from vTpcr.Q22 ORDER BY cntrycode -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1254) Detect session scoped temp tables in setting determism

by Steven Hawkins (JIRA)

Detect session scoped temp tables in setting determism ------------------------------------------------------ Key: TEIID-1254 URL: https://jira.jboss.org/browse/TEIID-1254 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1 The usage of session scoped temp tables should be detected to determine the determinism level of a command/results. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1104) Teiid engine will be clusterable.

by Van Halbert (JIRA)

Teiid engine will be clusterable. --------------------------------- Key: TEIID-1104 URL: https://jira.jboss.org/browse/TEIID-1104 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Van Halbert Assignee: Steve Hawkins The Teiid engine must support the ability to be clustered. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1008) Correlated subquery handling for Oracle/MySQL

by Steven Hawkins (JIRA)

Correlated subquery handling for Oracle/MySQL --------------------------------------------- Key: TEIID-1008 URL: https://jira.jboss.org/jira/browse/TEIID-1008 Project: Teiid Issue Type: Quality Risk Components: Connector API, Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 Most version of Oracle and MySQL only support one level of nesting for correlated reference appearing in non-inlineview subqueries. These queries are perfectly legal in Teiid and sources such as PostgreSQL. To work around we'll need to add a new capability and planner logic to prevent pushdown. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1148) Require the use of CXF

by Steve Hawkins (JIRA)

Require the use of CXF ---------------------- Key: TEIID-1148 URL: https://jira.jboss.org/browse/TEIID-1148 Project: Teiid Issue Type: Sub-task Components: XML Connector Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 Given the current direction of the JBoss WS project and that the other SOA projects do not have a specific implementation target, we can require the use of CXF. There are some additional installation steps needed that will be added to the admin guide / release notes. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 3 months

3
11
0 / 0

[JBoss JIRA] Created: (TEIID-1249) VDB scoped cached results not checked for access

by Steven Hawkins (JIRA)

VDB scoped cached results not checked for access ------------------------------------------------ Key: TEIID-1249 URL: https://jira.jboss.org/browse/TEIID-1249 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1 VDB scoped cached result for user queries are not being validated against applicable roles. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 3 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1215) Add a performance tuning chapter to the admin guide

by Steve Hawkins (JIRA)

Add a performance tuning chapter to the admin guide --------------------------------------------------- Key: TEIID-1215 URL: https://jira.jboss.org/browse/TEIID-1215 Project: Teiid Issue Type: Feature Request Components: Documentation Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 The admin guide should have a performance chapter especially to cover buffer manager configuration. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 3 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1368) "Each" should be a parser keyword

by Steven Hawkins (JIRA)

"Each" should be a parser keyword --------------------------------- Key: TEIID-1368 URL: https://jira.jboss.org/browse/TEIID-1368 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.3 Each should be a reserved word in the parser. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 3 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1250) Allow usage of select expressions in order by, even with group by/distinct.

by Steven Hawkins (JIRA)

Allow usage of select expressions in order by, even with group by/distinct. --------------------------------------------------------------------------- Key: TEIID-1250 URL: https://jira.jboss.org/browse/TEIID-1250 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.2 We currently do not allow order by keys to reference anything other select aliases if a simple query uses distinct or group by. We could allow for the projected expressions to resolve as well. For example: select x as y from t group by x order by x instead of order by y Mondrian generates queries of this form, although I'm not sure if that's something that could be customized through Mondrian. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 3 months

1
2
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2010