January 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1543) Add a query hint to limit the number of concurrent source queries

by Steven Hawkins (JIRA)

Add a query hint to limit the number of concurrent source queries ----------------------------------------------------------------- Key: TEIID-1543 URL: https://issues.jboss.org/browse/TEIID-1543 Project: Teiid Issue Type: Sub-task Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins We would like a new query hint to limit the number of parallel executions of union members. This is useful in two situations: 1. When the queries are expensive, but the overall union contains a limit that is most likely to be fulfilled by the first member of the union 2. When the queries are backed by a common resource which may be overloaded by multiple queries The addition of a hint would make this manageable by the client; perhaps something like "/*+ parallel=2*/"? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic

by Steve Hawkins (JIRA)

Reuse dynamic sql plans and allow for prepared statements in procedure logic ---------------------------------------------------------------------------- Key: TEIID-1226 URL: https://jira.jboss.org/browse/TEIID-1226 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Priority: Minor Fix For: 8.0 Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse. Also procedure logic should have a mechanism to execute prepared statements for further plan reuse. -- 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

12 years, 2 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-1248) Clob usability

by Steven Hawkins (JIRA)

Clob usability -------------- Key: TEIID-1248 URL: https://jira.jboss.org/browse/TEIID-1248 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 In many circumstances, clobs should be treated as charsequences to allow for use in string functions (concat returning clob, insert, left, etc.). There have also been customer requests to treat clobs as comparable, but that there are a lot of places including at design time where we validate against clobs being comparable that it may not be a good idea. -- 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

12 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1700) Move odbc cursor logic to engine

by Steven Hawkins (JIRA)

Move odbc cursor logic to engine -------------------------------- Key: TEIID-1700 URL: https://issues.jboss.org/browse/TEIID-1700 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 ODBC added support for declared cursors, which would be a good general/procedure language feature. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

2
9
0 / 0

[JBoss JIRA] Created: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Paul Nittel (JIRA)

Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries -------------------------------------------------------------------------------------------------------------- Key: TEIID-1377 URL: https://jira.jboss.org/browse/TEIID-1377 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1.1 Reporter: Paul Nittel Assignee: Steven Hawkins When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

5
11
0 / 0

[JBoss JIRA] (TEIID-1850) Add support for GreenPlum Database as a source

by Ken Johnson (Created) (JIRA)

Add support for GreenPlum Database as a source ---------------------------------------------- Key: TEIID-1850 URL: https://issues.jboss.org/browse/TEIID-1850 Project: Teiid Issue Type: Feature Request Affects Versions: 7.5 Reporter: Ken Johnson Assignee: Steven Hawkins Consider adding (or perhaps just validating) support for Greenplum. It's based on Postgres and uses the PG jdbc driver. Community version available for download. -- 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, 4 months

3
4
0 / 0

[JBoss JIRA] (TEIID-1871) Teiid is handling MySQL5.0 returning DAYNAME as a blob

by Paul Nittel (Created) (JIRA)

Teiid is handling MySQL5.0 returning DAYNAME as a blob ------------------------------------------------------ Key: TEIID-1871 URL: https://issues.jboss.org/browse/TEIID-1871 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: mysql-connector-java-5.0.8-bin.jar, QT_MySql50_Push-ds.xml, QT_MySql50_Push.vdb SELECT IntKey, DAYNAME(datevalue) FROM BQT1.SmallA ORDER BY IntKey LIMIT 10 Fails with: Caught SQLException: Invalid conversion from type class org.teiid.core.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob@6482112e' to type class java.lang.String Dev indicaters, "The driver returns the bytes, which we treat as a blob. We have an explicit workaround in the translator for the char function, but I've never seen this outside of the char function. There may be an issue with the http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysva... setting also that could influence how the value is returned." The server setting is en_US. -- 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, 4 months

6
12
0 / 0

[JBoss JIRA] (TEIID-1840) The Jdbc Socket Host Name Propertie cannot be changed in admin console

by Nagai Eiichi (Created) (JIRA)

The Jdbc Socket Host Name Propertie cannot be changed in admin console ---------------------------------------------------------------------- Key: TEIID-1840 URL: https://issues.jboss.org/browse/TEIID-1840 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 7.4 Reporter: Nagai Eiichi Assignee: Steven Hawkins The Jdbc Socket Host Name property cannot be changed in admin console. -- 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, 4 months

6
6
0 / 0

[JBoss JIRA] (TEIID-1911) Deploy time cached VDB metadata is being deleted during shutdown.

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-1911: ----------------------------------- Summary: Deploy time cached VDB metadata is being deleted during shutdown. Key: TEIID-1911 URL: https://issues.jboss.org/browse/TEIID-1911 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Critical Fix For: 8.0 Due to https://issues.jboss.org/browse/AS7-3431 the metadata is always being deleted during the shutdown. This will be bigger issue with dynamic VDBs. -- 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, 4 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1751) Scalar function reference issues

by Steven Hawkins (JIRA)

Scalar function reference issues -------------------------------- Key: TEIID-1751 URL: https://issues.jboss.org/browse/TEIID-1751 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 7.4.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 Generic issue for on-going corrections/improvements to scalar function docs. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
3
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2012