March 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1904) Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate

by Ganesh Kumar (JIRA)

Ganesh Kumar created TEIID-1904: ----------------------------------- Summary: Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate Key: TEIID-1904 URL: https://issues.jboss.org/browse/TEIID-1904 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6, 7.3 Environment: Windows 7 JDK 1.6.0_23 Jboss 5.1.0.GA Reporter: Ganesh Kumar Assignee: Steven Hawkins I have a VDB which has a multi-source model. I have a prepared statement for which SOURCE_NAME is passed as a parameter. When this prepared statement is executed, I get an exception [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate ?: No value was available This exception does not occur when I specify other conditions in combination with SOURCE_NAME. Also, the query works fine when SOURCE_NAME value is not a parameter, that is, its value is provided in the query. -- 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, 7 months

2
7
0 / 0

[JBoss JIRA] (TEIID-1870) Querying random number from DB2 v97 does not push down to source

by Paul Nittel (Created) (JIRA)

Querying random number from DB2 v97 does not push down to source ---------------------------------------------------------------- Key: TEIID-1870 URL: https://issues.jboss.org/browse/TEIID-1870 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Reporter: Paul Nittel Assignee: Steven Hawkins When I query SELECT RAND(), IntKey from SmallA using DB2 directly, I get back: 1,INTKEY 0.00125,0 0.56359,1 0.1933,2 0.80874,3 Using the equivalent SQL through Teiid to DB2, I get: expr,IntKey 0.86867,0 0.86867,1 0.86867,2 0.86867,3 The command log entry for the Teiid query looks like this: 2011-12-14 07:50:22,093 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-2 START USER COMMAND: startTime=2011-12-14 07:50:22.093 requestID=KURKVzpMf/MI.12 txID=null sessionID=KURKVzpMf/MI applicationName=JDBC principal=user@teiid-security vdbName=QT_db2v97ds_Push vdbVersion=1 sql=select rand(), curtime(), intkey from bqt1.smalla limit 5 2011-12-14 07:50:22,099 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue1394 START DATA SRC COMMAND: startTime=2011-12-14 07:50:22.098 requestID=KURKVzpMf/MI.12 sourceCommandID=0 txID=null modelName=Source connectorBindingName=db2 sessionID=KURKVzpMf/MI principal=user@teiid-security sql=SELECT convert(g_0.INTKEY, integer) AS c_2 FROM Source.SMALLA AS g_0 LIMIT 5 2011-12-14 07:50:22,394 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue1396 END SRC COMMAND: endTime=2011-12-14 07:50:22.394 requestID=KURKVzpMf/MI.12 sourceCommandID=0 txID=null modelName=Source connectorBindingName=db2 sessionID=KURKVzpMf/MI principal=user@teiid-security finalRowCount=5 2011-12-14 07:50:22,427 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue1397 END USER COMMAND: endTime=2011-12-14 07:50:22.427 requestID=KURKVzpMf/MI.12 txID=null sessionID=KURKVzpMf/MI principal=user@teiid-security vdbName=QT_db2v97ds_Push vdbVersion=1 finalRowCount=0 The source command appears to be lacking the rand() function call. In response, dev says, "So the issue here is that the final rewrite of the pushdown query is pre-evaluating the non-deterministic pushdown function. If the function were not pushed-down you would get something more like you would expect." -- 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, 7 months

5
5
0 / 0

[JBoss JIRA] Created: (TEIID-1687) GSSAPI support for postgres emulation layer

by Graeme Gillies (JIRA)

GSSAPI support for postgres emulation layer ------------------------------------------- Key: TEIID-1687 URL: https://issues.jboss.org/browse/TEIID-1687 Project: Teiid Issue Type: Feature Request Affects Versions: 7.4 Environment: All Reporter: Graeme Gillies Assignee: Steven Hawkins Priority: Minor Similar to TEIID-1610 Postgres clients support authentication via GSSAPI http://www.google.com/url?sa=t&source=web&cd=2&ved=0CB4QFjAB&url=http%3A%... It would be great if teiid's postgres emulation layer would allow it to support GSSAPI as an authentication mechanism from clients. Server side you could setup a keytab with the correct server side principal postgres/$fqdn(a)REALM.COM which teiid would use to authenticate clients connecting to it via the postgres emulation layer. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 7 months

5
4
0 / 0

[JBoss JIRA] (TEIID-1894) Consolidate bulk/iterator based inserts

by Steven Hawkins (Created) (JIRA)

Consolidate bulk/iterator based inserts --------------------------------------- Key: TEIID-1894 URL: https://issues.jboss.org/browse/TEIID-1894 Project: Teiid Issue Type: Quality Risk Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 There is redundancy and inconsistency in the translator api around performing bulk/iterator based updates. These should be consolidated to a single execution model. -- 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, 7 months

4
3
0 / 0

[JBoss JIRA] (TEIID-1932) Add comparable lob logic to 7.7

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1932: ------------------------------------- Summary: Add comparable lob logic to 7.7 Key: TEIID-1932 URL: https://issues.jboss.org/browse/TEIID-1932 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.7 Back-port the comparable lob logic from TEIID-1834 from 8.0 to 7.7 -- 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, 7 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1540) Add the ability to delegate one shot dependent joins to the translators

by Steven Hawkins (JIRA)

Add the ability to delegate one shot dependent joins to the translators ----------------------------------------------------------------------- Key: TEIID-1540 URL: https://issues.jboss.org/browse/TEIID-1540 Project: Teiid Issue Type: Sub-task Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 Using a memory safe iterator, like with bulk handling, we should be able to push dependent joins to the translator to perform specialized source specific one-shot join handling. With the other dependent join improvements this should hopefully be needed only in the most extreme cases. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 7 months

3
4
0 / 0

[JBoss JIRA] (TEIID-1864) TIMESTAMPADD of SQL_TSI_FRAC_SECOND fails for Sybase 15 with JConnect 6.0.5 driver

by Paul Nittel (Created) (JIRA)

TIMESTAMPADD of SQL_TSI_FRAC_SECOND fails for Sybase 15 with JConnect 6.0.5 driver ---------------------------------------------------------------------------------- Key: TEIID-1864 URL: https://issues.jboss.org/browse/TEIID-1864 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Reporter: Paul Nittel Assignee: Steven Hawkins Executing this query: SELECT intkey, timestampvalue, TIMESTAMPADD(SQL_TSI_FRAC_SECOND,123,TIMESTAMPVALUE) FROM BQT1.SMALLA WHERE INTKEY < 10 ORDER BY INTKEY errors in the following fashion: [JDBCExecutionException] 0: Error Code:0 Message:'JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.IntKey AS c_0, g_0.TimestampValue AS c_1, {fn timestampadd(SQL_TSI_FRAC_SECOND, 123, g_0.TimestampValue)} AS c_2 FROM SmallA g_0 WHERE g_0.IntKey < 10 ORDER BY c_0] 1 [SQLException]JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server. at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:272) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:342) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server. at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.processEscapes(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.doEscapeProcessing(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.<init>(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:460) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:172) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84) ... 13 more Executing the same query using the JTDS 1.2.5 driver works correctly. -- 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, 7 months

5
5
0 / 0

[JBoss JIRA] (TEIID-1875) Convert community docs to confluence

by Steven Hawkins (Created) (JIRA)

Convert community docs to confluence ------------------------------------ Key: TEIID-1875 URL: https://issues.jboss.org/browse/TEIID-1875 Project: Teiid Issue Type: Task Components: Documentation Reporter: Steven Hawkins Fix For: 8.0 Our confluence instance https://docs.jboss.org/author/dashboard.action and associated docbook import https://issues.jboss.org/browse/ORG-965 should be used to produce an online version of the docs. Export actions will need to be used in maven the produce distributable forms with our artifacts. -- 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, 7 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-1352) Produce Admin API jar containing only Interfaces.

by John Doyle (JIRA)

Produce Admin API jar containing only Interfaces. ------------------------------------------------- Key: TEIID-1352 URL: https://jira.jboss.org/browse/TEIID-1352 Project: Teiid Issue Type: Feature Request Components: AdminApi Reporter: John Doyle Assignee: Steven Hawkins TEIIDDES-175 requires the creation of a target runtime for Teiid so that the tooling can be further abstracted from changes in Teiid. In order to accomplish this the tooling requires an Admin API jar containing only interfaces. The Designer code that depends upon the Admin API could be compiled with this jar, and the plug-in defining the target runtime would load the implementation of the Admin API at runtime. -- 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, 7 months

7
11
0 / 0

[JBoss JIRA] (TEIID-1820) like_regex only matches full string patterns

by Steven Hawkins (Created) (JIRA)

like_regex only matches full string patterns -------------------------------------------- Key: TEIID-1820 URL: https://issues.jboss.org/browse/TEIID-1820 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6 like_regex currently asks the compiled pattern matcher if the pattern matches in full, not for the first occurrence. This means that a pattern such as 'a' will not match 'cat'. -- 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, 7 months

5
6
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2012