May 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1534) The driver incorrectly reports column labels as column names

by Steven Hawkins (JIRA)

The driver incorrectly reports column labels as column names ------------------------------------------------------------ Key: TEIID-1534 URL: https://issues.jboss.org/browse/TEIID-1534 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The metadata for column names are actually column labels and the real value for the column name is not actually reported by the MetadataProcesor. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-513) Make the commandcontext available to the evaluatablevisitor

by Steven Hawkins (JIRA)

Make the commandcontext available to the evaluatablevisitor ----------------------------------------------------------- Key: TEIID-513 URL: https://jira.jboss.org/jira/browse/TEIID-513 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x If the commandcontext is available to the evaluatablevisitor, then we can make a better decision about what determinism level to accept for planning function evaluation. -- 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

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1574) Add new permission types for alter/execute

by Steven Hawkins (JIRA)

Add new permission types for alter/execute ------------------------------------------ Key: TEIID-1574 URL: https://issues.jboss.org/browse/TEIID-1574 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 In addition to CRUD, we should have more idiomatic permissions for allowing alter (alter) statements and for procedure/function execution (execute). For backwards compatibility READ would still be accepted as the execute permission. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1572) Teiid ODBC does not handle SET and Show operations correctly

by Ramesh Reddy (JIRA)

Teiid ODBC does not handle SET and Show operations correctly ------------------------------------------------------------ Key: TEIID-1572 URL: https://issues.jboss.org/browse/TEIID-1572 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.2 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.4 - ODBC protocol expects 'SET' string as command completion when a SET command is issued, this is being ignored - PG lets user query the database on configuration using SHOW command. Teiid supports the SHOW command, however since not all properties defined during initialization and some defaults not set explicitly they are not available for the SHOW command. This command being used by Python client. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1595) User without required role is able to explicitly create a temporary table

by Paul Nittel (JIRA)

User without required role is able to explicitly create a temporary table ------------------------------------------------------------------------- Key: TEIID-1595 URL: https://issues.jboss.org/browse/TEIID-1595 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Paul Nittel Assignee: Steven Hawkins In testing roles, I created a VDB with roles, some of which permit the creation of temporary tables. It turns out Teiid allows creation of temporary tables whether or not you're allowed to. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1571) Error due to merge virtual with join and group by

by Steven Hawkins (JIRA)

Error due to merge virtual with join and group by ------------------------------------------------- Key: TEIID-1571 URL: https://issues.jboss.org/browse/TEIID-1571 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 A query such as "SELECT x FROM (select c.e1 as x from (select e1 from pm1.g1) as c, pm1.g2 as d) as a group by x" will fail with invalid group by column aliases due to an invalid merge. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1583) importer.useFullSchemaName property default value is incorrectly documented

by Scott Dawson (JIRA)

importer.useFullSchemaName property default value is incorrectly documented --------------------------------------------------------------------------- Key: TEIID-1583 URL: https://issues.jboss.org/browse/TEIID-1583 Project: Teiid Issue Type: Bug Affects Versions: 7.3 Environment: JBoss AS 5.1 Teiid 7.3 Reporter: Scott Dawson Assignee: Steven Hawkins In the Teiid Reference Document, table 10.4 'Importer Properties' in section 10.2.2 'JDBC Translator', specifies the default value for the useFullSchemaName property as 'true' which is incorrect, it defaults to 'false'. As Ramesh Reddy says in the forum thread (see forum link), it may be preferable to change the code to match the documentation. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-776) Enhancem multisource planning with aggregate pushdown

by Steven Hawkins (JIRA)

Enhancem multisource planning with aggregate pushdown ----------------------------------------------------- Key: TEIID-776 URL: https://jira.jboss.org/jira/browse/TEIID-776 Project: Teiid Issue Type: Feature Request Affects Versions: 6.2.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x Multisource modification happens after all rules have been fired, which means that aggregate and other sort/distinct pushdown optimizations do not happen. -- 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

12 years, 10 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1588) Failover does not work correctly when server nodes are behind proxy

by Boris Belovic (JIRA)

Failover does not work correctly when server nodes are behind proxy ------------------------------------------------------------------- Key: TEIID-1588 URL: https://issues.jboss.org/browse/TEIID-1588 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Environment: Fedora 14, JDK1.6 Reporter: Boris Belovic Assignee: Steven Hawkins I wrote simple proxy which simply send data from one port to another. I've put 2 node cluster behind this proxy. Proxy works like this: Client connects to the interface of a proxy and then proxy send all data to cluster. When I stop the proxy, the proxy stops sending data from client to server - this is used as a simulation of cluster node failure. Then I ran this scenario: 1. Query data from cluster, data retrieved without any problems. 2. Then, on the proxy I tried to turn off (block access to) each node of a cluster. When I stop the proxy I've got following exception: May 16, 2011 1:50:04 PM org.teiid.jdbc.StatementImpl executeSql [testng] WARNING: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE. [testng] org.teiid.jdbc.TeiidSQLException: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) [testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) [testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:917) [testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:479) [testng] at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:324) [testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.select(TeiidClusteringTest.java:141) [testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.testFailover(TeiidClusteringTest.java:72) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:641) [testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:677) [testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:850) [testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1154) [testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:137) [testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121) [testng] at org.testng.TestRunner.runWorkers(TestRunner.java:1108) [testng] at org.testng.TestRunner.privateRun(TestRunner.java:737) [testng] at org.testng.TestRunner.run(TestRunner.java:596) [testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:315) [testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:310) [testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:272) [testng] at org.testng.SuiteRunner.run(SuiteRunner.java:221) [testng] at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) [testng] at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) [testng] at org.testng.TestNG.runSuitesSequentially(TestNG.java:1027) [testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:964) [testng] at org.testng.TestNG.run(TestNG.java:896) [testng] at org.testng.TestNG.privateMain(TestNG.java:1193) [testng] at org.testng.TestNG.main(TestNG.java:1153) [testng] Caused by: java.util.concurrent.ExecutionException: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:317) [testng] at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:348) [testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:915) [testng] ... 28 more [testng] Caused by: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199) [testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:107) [testng] at $Proxy12.read(Unknown Source) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347) [testng] ... 29 more [testng] Caused by: java.io.EOFException [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:166) [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147) [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81) [testng] at java.io.ObjectInputStream.readObject(ObjectInputStream.java:344) [testng] at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114) [testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253) [testng] ... 36 more [testng] org.teiid.jdbc.TeiidSQLException: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE. [testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:102) [testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:483) [testng] at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:324) [testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.select(TeiidClusteringTest.java:141) [testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.testFailover(TeiidClusteringTest.java:72) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:641) [testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:677) [testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:850) [testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1154) [testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:137) [testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121) [testng] at org.testng.TestRunner.runWorkers(TestRunner.java:1108) [testng] at org.testng.TestRunner.privateRun(TestRunner.java:737) [testng] at org.testng.TestRunner.run(TestRunner.java:596) [testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:315) [testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:310) [testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:272) [testng] at org.testng.SuiteRunner.run(SuiteRunner.java:221) [testng] at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) [testng] at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) [testng] at org.testng.TestNG.runSuitesSequentially(TestNG.java:1027) [testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:964) [testng] at org.testng.TestNG.run(TestNG.java:896) [testng] at org.testng.TestNG.privateMain(TestNG.java:1193) [testng] at org.testng.TestNG.main(TestNG.java:1153) [testng] Caused by: org.teiid.jdbc.TeiidSQLException: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) [testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) [testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:917) [testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:479) [testng] ... 27 more [testng] Caused by: java.util.concurrent.ExecutionException: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:317) [testng] at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:348) [testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:915) [testng] ... 28 more [testng] Caused by: [SingleInstanceCommunicationException] [testng] 1 [EOFException] [testng] at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199) [testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:107) [testng] at $Proxy12.read(Unknown Source) [testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347) [testng] ... 29 more [testng] Caused by: java.io.EOFException [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:166) [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147) [testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81) [testng] at java.io.ObjectInputStream.readObject(ObjectInputStream.java:344) [testng] at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114) [testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253) [testng] ... 36 more [testng] @@ Message: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

4
13
0 / 0

[JBoss JIRA] Created: (TEIID-1579) LocalServer Connection is working

by Ramesh Reddy (JIRA)

LocalServer Connection is working --------------------------------- Key: TEIID-1579 URL: https://issues.jboss.org/browse/TEIID-1579 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.4 Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Critical Fix For: 7.4 Using the InVM client, connection made to the Teiid ended with error. There seems to be some timing issue that is making it hang. See attached for the testing tools. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2011