May 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1545) Order By not pushed down

by Mark Addleman (JIRA)

Order By not pushed down ------------------------ Key: TEIID-1545 URL: https://issues.jboss.org/browse/TEIID-1545 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Reporter: Mark Addleman Assignee: Steven Hawkins ORDER BY is not pushed down in the following query: SELECT J0.APPNAME, B.\"SYSID\", B.\"USERID\", (select count(*) from (select * from notes.RETRIEVE_NOTES where OBJECT_PKEY = B.USERID) as foo) as C_notesForObject FROM \"SECURITY.BASEUSER\" as B left join security.sysinfo J0 on J0.sysid=B.sysid ORDER BY J0.APPNAME ASC SECURITY comes from the DB2 translator notes comes from a programmatic translator which does not support ORDER BY -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

3
6
0 / 0

[JBoss JIRA] Created: (TEIID-1512) show plan statement clob isn't readable

by Steven Hawkins (JIRA)

show plan statement clob isn't readable --------------------------------------- Key: TEIID-1512 URL: https://issues.jboss.org/browse/TEIID-1512 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The show plan statement produces clobs that are unreadable. This is because the resultset treats them as remote instead of local. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1521) Dynamic vdb import logic error with procedures

by Steven Hawkins (JIRA)

Dynamic vdb import logic error with procedures ---------------------------------------------- Key: TEIID-1521 URL: https://issues.jboss.org/browse/TEIID-1521 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 When importing procedure metadata the enum for parameter type does not include result parameters, which causes an exception for return parameters. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1367) Add VDB Level Clear Cache Operation in Jopr/JON

by Ted Jones (JIRA)

Add VDB Level Clear Cache Operation in Jopr/JON ----------------------------------------------- Key: TEIID-1367 URL: https://jira.jboss.org/browse/TEIID-1367 Project: Teiid Issue Type: Feature Request Components: Jopr Plugin Affects Versions: 7.1 Reporter: Ted Jones Assignee: Ted Jones Priority: Critical Fix For: 7.1.1 Need to add an operation to clear the Prepared Plan and/or Result Set caches. This should be a VDB level operation. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1011) Add support for connecting to Mondrian

by Steven Hawkins (JIRA)

Add support for connecting to Mondrian -------------------------------------- Key: TEIID-1011 URL: https://jira.jboss.org/jira/browse/TEIID-1011 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 We should add support for connecting to Mondrian (and multidimensional datasources in general) through http://www.jdbc4olap.org/. -- 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

13 years, 5 months

4
12
0 / 0

[JBoss JIRA] Created: (TEIID-1434) Example dynamicvdb-portfolio customer-schema.sql INSERT INTO HOLDINGS has PRODUCT_ID references that don't exist in PRODUCT table causing sql to fail

by Van Halbert (JIRA)

Example dynamicvdb-portfolio customer-schema.sql INSERT INTO HOLDINGS has PRODUCT_ID references that don't exist in PRODUCT table causing sql to fail -------------------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1434 URL: https://issues.jboss.org/browse/TEIID-1434 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 7.2, 7.1.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Minor The customer-schema.sql contains insert statements into HOLDINGS that contain references to PRODUCT table that don't exist. Example: INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1020,{ts '2001-08-22 00:00:00.000'},70); Product_ID references to 1020 and 1022 don't exist. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1364) Provide a Means of Filtering Preview VDBs in Jopr/JON

by Ted Jones (JIRA)

Provide a Means of Filtering Preview VDBs in Jopr/JON ----------------------------------------------------- Key: TEIID-1364 URL: https://jira.jboss.org/browse/TEIID-1364 Project: Teiid Issue Type: Feature Request Components: Jopr Plugin Reporter: Ted Jones Assignee: Ted Jones Need a configuration property to determine whether preview vdbs should display or not. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1440) Add support for not null and auto increment for temp table columns

by Steven Hawkins (JIRA)

Add support for not null and auto increment for temp table columns ------------------------------------------------------------------ Key: TEIID-1440 URL: https://issues.jboss.org/browse/TEIID-1440 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.3 It would be good to have auto increment and not null support for temp tables. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1228) Add JOPR data role display

by Steve Hawkins (JIRA)

Add JOPR data role display -------------------------- Key: TEIID-1228 URL: https://jira.jboss.org/browse/TEIID-1228 Project: Teiid Issue Type: Sub-task Components: Jopr Plugin Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 Data roles should be displayed in JOPR. It would be optional to include the actual permissions. The mapped role names property should be updatable (which includes add/remove). -- 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

13 years, 5 months

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1520) Reduce the memory footprint of metadata

by Steven Hawkins (JIRA)

Reduce the memory footprint of metadata --------------------------------------- Key: TEIID-1520 URL: https://issues.jboss.org/browse/TEIID-1520 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The strings held in the querymetadatainterface cache and by the metadata/resolved symbols should be optimized. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2011