February 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-934) MySql Queries - SQL syntax error on pushdown queries when using functions like LPAD, REPLACE, etc

by Warren Gibson (JIRA)

MySql Queries - SQL syntax error on pushdown queries when using functions like LPAD, REPLACE, etc ------------------------------------------------------------------------------------------------- Key: TEIID-934 URL: https://jira.jboss.org/jira/browse/TEIID-934 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Warren Gibson Assignee: Steven Hawkins Several CTC queries are failing in MySql when they are pushed down to the source. See query example and resulting SQL error below: SELECT INTKEY, LPAD(TIMESTAMPVALUE, 18) FROM BQT1.SmallA ORDER BY INTKEY Error Code:1064 Message:Error Code:1064 Message:Error occurred on connector MySQL_Push<5> - Error Code:1064 Message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS c_1 FROM smalla AS g_0 ORDER BY c_0' at line 1 Executing statement: [SQL: SELECT cast(g_0.INTKEY AS signed) AS c_0, LPAD(date_format(g_0.TIMESTAMPVALUE, '%Y-%m-%d %H:%i:%S.%f'), 18) AS c_1 FROM smalla AS g_0 ORDER BY c_0] -- 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, 11 months

3
7
0 / 0

[JBoss JIRA] Created: (TEIID-893) XML Formatting error in Dynamic VDB (.def) file presents to user as file not found

by Paul Nittel (JIRA)

XML Formatting error in Dynamic VDB (.def) file presents to user as file not found ---------------------------------------------------------------------------------- Key: TEIID-893 URL: https://jira.jboss.org/jira/browse/TEIID-893 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Environment: Fedora 10, Teiid 7.0 M1 snapshot Reporter: Paul Nittel Assignee: Steven Hawkins I created paul.def which contained a connector to Oracle. When I tried to query anything (for example, "SELECT 1;"), I received an error that indicated the paul.def file was not found. After patching Teiid to produce a better message, we found I had fat-fingered the XML in the .def. Would have saved a bunch o' time had the correct error message been shown in the beginning. -- 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, 11 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-899) Virtual Procedure queries with input variables failing with "No value was available."

by Paul Nittel (JIRA)

Virtual Procedure queries with input variables failing with "No value was available." ------------------------------------------------------------------------------------- Key: TEIID-899 URL: https://jira.jboss.org/jira/browse/TEIID-899 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Environment: Fedora 10; Teiid 7.0.0M1 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: QT_ora11ds.vdb, teiidEXEC.log This does not mean that all virtual procedures with input variables are failing... Just these 3 in particular. Read on! There are 3 queries of virtual procedures that are consistently failing for all sources. For example, this one: EXEC VirtProcs.dyno( '04:00:00', -125 ) gets an exception that reads, "Target exception: com.metamatrix.jdbc.MMSQLException: Error Code:ERR.015.006.0033 Message:Unable to evaluate VIRTPROCS.DYNO.TIMEIN: No value was available". I cranked up the logging to DEBUG and have included the log file (and VDB) in case you want to see more detail. Running this query against these models in a 6.2 Designer, it's OK. I took that VDB, deployed in a 7.0 Teiid, and the query fails. The other failing queries are: SELECT DNT FROM VirtProcs.vDate_n_Time WHERE intkey_in = 2 SELECT intkey , timevalue , bytenum FROM bqt1.largea WHERE largea.intkey IN ( SELECT rs_intkey FROM ( EXEC VirtProcs.dyno ( '04:00:00' , -125 )) AS foo ) The third is really just a variation of the first. Log and VDB are attached. -- 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, 11 months

3
6
0 / 0

[JBoss JIRA] Created: (TEIID-868) Simplify handling of parse format date/time functions

by Steven Hawkins (JIRA)

Simplify handling of parse format date/time functions ----------------------------------------------------- Key: TEIID-868 URL: https://jira.jboss.org/jira/browse/TEIID-868 Project: Teiid Issue Type: Task Components: Query Engine Affects Versions: 6.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3 There is no need to have separate implementations and pushdown paths for parsedate/parsetime, etc. They should just be rewritten forms of parse/formattimestamp. Also timestampadd is typically implemented to expect and return a timestamp, so non-timestamp forms should be rewritten to the timestamp form. -- 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, 11 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-912) Add unit test methods from JBEDSP-1137: StackOverflowError when top level query uses the same symbol name and group alias that is in a second level query or sub-query

by Larry O'Leary (JIRA)

Add unit test methods from JBEDSP-1137: StackOverflowError when top level query uses the same symbol name and group alias that is in a second level query or sub-query ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-912 URL: https://jira.jboss.org/jira/browse/TEIID-912 Project: Teiid Issue Type: Task Components: Query Engine Affects Versions: 7.0 Reporter: Larry O'Leary Assignee: Larry O'Leary Fix For: 7.0 Add test coverage from JBEDSP-1137 that covers the following use case: SELECT CONVERT(A.e2, biginteger) AS e2 FROM ( SELECT CONVERT(e2, long) AS e2 FROM ( SELECT 5 AS e2 ) AS A ) AS A -- 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, 11 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-870) Standardize the JDBC metadata

by Steven Hawkins (JIRA)

Standardize the JDBC metadata ----------------------------- Key: TEIID-870 URL: https://jira.jboss.org/jira/browse/TEIID-870 Project: Teiid Issue Type: Sub-task Components: JDBC Driver Affects Versions: 6.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3 The current JDBC metadata: catalog = null schema = vdbname (except when getSchemas is used, then it's reported as model name) table = table full name proposed change (which is much closer to what was done for OA ODBC metadata): catalog = vdbname schema = model name table = the rest of the table name including "." if a schema/catalog is in the model -- 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, 11 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-875) DatabaseMetadata issues

by Steven Hawkins (JIRA)

DatabaseMetadata issues ----------------------- Key: TEIID-875 URL: https://jira.jboss.org/jira/browse/TEIID-875 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3 MMDatabaseMetadata getColumns is_nullable has YES/NO reversed getIndexInfo should return both unique and non-unique indexes -- 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, 11 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-867) Possibly Teiid embedded clients (Designer) not pinging query engine, causing session timeouts

by Paul Nittel (JIRA)

Possibly Teiid embedded clients (Designer) not pinging query engine, causing session timeouts --------------------------------------------------------------------------------------------- Key: TEIID-867 URL: https://jira.jboss.org/jira/browse/TEIID-867 Project: Teiid Issue Type: Bug Environment: fedora 10, Teiid Designer 6.2 Reporter: Paul Nittel Assignee: Steven Hawkins I started the Teiid 6.2 Designer, executed a VDB and ran a simple query. Then I waited about 35 minutes and finally clicked the Running Dude(tm) button. Instead of nicely arranged rows of data, I got: Error 2009-09-30 14:41:48.107 Error processing query com.metamatrix.jdbc.MMSQLException: Error trying to execute a statement select IntKey, StringKey, IntNum, StringNum, FloatNum, LongNum, DoubleNum, ByteNum, DateValue, TimeValue, TimestampValue, BooleanValue, CharValue, ShortValue, BigIntegerValue, BigDecimalValue, ObjectValue from "SP"."BQT2.SmallA" . at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:116) at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:414) at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:318) at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192) at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Caused by: com.metamatrix.jdbc.MMSQLException: The specified session ID "2" is invalid. It cannot be found in the userbase. at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123) at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71) at com.metamatrix.jdbc.MMStatement.sendRequestMessageAndWait(MMStatement.java:855) at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:410) ... 4 more Caused by: [MetaMatrixComponentException]The specified session ID "2" is invalid. It cannot be found in the userbase. 1 [InvalidSessionException]The specified session ID "2" is invalid. It cannot be found in the userbase. at com.metamatrix.client.ExceptionUtil.convertException(ExceptionUtil.java:59) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:119) at $Proxy24.executeRequest(Unknown Source) at com.metamatrix.jdbc.MMStatement.sendRequestMessageAndWait(MMStatement.java:853) ... 5 more Caused by: [InvalidSessionException]The specified session ID "2" is invalid. It cannot be found in the userbase. at com.metamatrix.platform.security.session.service.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:295) at com.metamatrix.platform.security.session.service.SessionServiceImpl.validateSession(SessionServiceImpl.java:287) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:109) ... 7 more The session timeout property is commented out in the workspace.properties file. Steve Hawkins opined the embedded clients ae not pinging the server. -- 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, 11 months

4
4
0 / 0

[JBoss JIRA] Created: (TEIID-925) dup removal results include duplicat rows

by Steven Hawkins (JIRA)

dup removal results include duplicat rows ----------------------------------------- Key: TEIID-925 URL: https://jira.jboss.org/jira/browse/TEIID-925 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.0 Non-blocking dup removal batches are mishandled by the SortNode, since it expects batches to not overlap. Also the SortUtility incorrectly includes duplicates since the master sort tuple may be marked as a duplicate, but it's pair is not. -- 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, 11 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-750) Add more filtering in the internal processing of queries so that hidden items do not requires fully qualified names to be used

by Rob Hutton (JIRA)

Add more filtering in the internal processing of queries so that hidden items do not requires fully qualified names to be used ------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-750 URL: https://jira.jboss.org/jira/browse/TEIID-750 Project: Teiid Issue Type: Feature Request Components: Query Engine, Server Affects Versions: 6.1.0 Reporter: Rob Hutton Assignee: Steven Hawkins If you have a table in a source model and a table in a view model with the same name, you must use the fully qualified name of the view model table when querying the VDB even if the source model is not visible. It would be nice if the visibility flag was taken in to account when trying to resolve object names while querying the VDB -- 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, 11 months

3
5
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2010