June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3395) USER and ROLE tables should be exposed as System Tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3395?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3395. --------------------------------- > USER and ROLE tables should be exposed as System Tables > ------------------------------------------------------- > > Key: TEIID-3395 > URL: https://issues.jboss.org/browse/TEIID-3395 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Tom Johnston > Assignee: Steven Hawkins > > LIke most databases (i.e. Oracle has DBA_USERS and DBA_ROLES) TeiiD should have the same and be sourced from whatever security domain is being used. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3819) SimpleDB NullPointerException when inserting null value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3819?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3819. --------------------------------- > SimpleDB NullPointerException when inserting null value > ------------------------------------------------------- > > Key: TEIID-3819 > URL: https://issues.jboss.org/browse/TEIID-3819 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > Attachments: simpledb-vdb.xml, simpledb.cli > > > When performing INSERT query, where one of the values is null, NullPointerException is thrown. > Example query: > {code:sql} > INSERT INTO SMallA(ItemName,doublenum) VALUES ('nullRow',null) > {code} > Stack trace in teiid's console: > {code:plain} > 13:59:57,789 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue35) TEIID30019 Unexpected exception for request dypFs9C3QJ3B.14: java.lang.NullPointerException > at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.addAttribute(SimpleDBConnectionImpl.java:255) > at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performInsert(SimpleDBConnectionImpl.java:223) > at org.teiid.translator.simpledb.SimpleDBInsertExecute.execute(SimpleDBInsertExecute.java:52) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:363) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3717) Enable SNI (Server Name Indication) support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3717?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3717. --------------------------------- > Enable SNI (Server Name Indication) support > ------------------------------------------- > > Key: TEIID-3717 > URL: https://issues.jboss.org/browse/TEIID-3717 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > Enable SNI support -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3797) Use the term local consistently

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3797?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3797. --------------------------------- > Use the term local consistently > ------------------------------- > > Key: TEIID-3797 > URL: https://issues.jboss.org/browse/TEIID-3797 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > To not have confusion with Teiid embedded, we should use the term local consistently to refer to the in-vm connections. This means updating the docs/config and renaming the embeddedprofile to localprofile. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3581) Add a system function to return Teiid Server Name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3581?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3581. --------------------------------- > Add a system function to return Teiid Server Name > ------------------------------------------------- > > Key: TEIID-3581 > URL: https://issues.jboss.org/browse/TEIID-3581 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > A user has a 4 node Cluster and would like to get not only the sessionid, vdb and user but the node of the cluster that the user is connected to -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3758) Allow for a 2048 bit DH key exchange

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3758?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3758. --------------------------------- > Allow for a 2048 bit DH key exchange > ------------------------------------ > > Key: TEIID-3758 > URL: https://issues.jboss.org/browse/TEIID-3758 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > There's a general recommendation to migrate to longer dh key lengths - https://weakdh.org/imperfect-forward-secrecy-ccs15.pdf -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3751) NPE in GroupingNode on running a query with CTEs and GROUP BY clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3751?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3751. --------------------------------- > NPE in GroupingNode on running a query with CTEs and GROUP BY clause > -------------------------------------------------------------------- > > Key: TEIID-3751 > URL: https://issues.jboss.org/browse/TEIID-3751 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.12 > > > Running the following query: > {code:sql} > WITH x as ( > SELECT a FROM my.test_a > ) > SELECT > p.a, > SUM(p.b) OVER (partition by p.a) as y > FROM > my.test_a p JOIN x ON x.a = p.a > GROUP BY p.a > {code} > I get two different exceptions, depending if the query is fully pushed down (like in PostgreSQL) or not (like in MySQL). > In the first case (not fully pushed down - MySQL), this NPE is thrown: > {code:sql} > 16:23:22,638 ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue5) NOliW/x7idDC TEIID30019 Unexpected exception for request NOliW/x7idDC.3: java.lang.NullPointerException > at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:218) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:344) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > {code} > If the query is pushed down (PostgreSQL), the following error comes directly from the underlying DBMS: > {code:sql} > 16:25:26,306 WARN [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue7) NOliW/x7idDC Connector worker process failed for atomic-request=NOliW/x7idDC.4.2.1: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH x (a) AS (SELECT g_0."a" FROM "public"."test_a" AS g_0) SELECT g_0."a" AS c_0, SUM(g_0."b") OVER (PARTITION BY g_0."a") AS c_1 FROM "public"."test_a" AS g_0, x AS g_1 WHERE g_1.a = g_0."a" GROUP BY g_0."a" LIMIT 100] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.0.CR1.jar:8.12.0.CR1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_67] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_67] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_67] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_67] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > Caused by: org.postgresql.util.PSQLException: ERROR: column "g_0.b" must appear in the GROUP BY clause or be used in an aggregate function > Position: 89 > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.12.0.CR1.jar:8.12.0.CR1] > ... 18 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3581) Add a system function to return Teiid Server Name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3581?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3581: ---------------------------------- Fix Version/s: 8.13 > Add a system function to return Teiid Server Name > ------------------------------------------------- > > Key: TEIID-3581 > URL: https://issues.jboss.org/browse/TEIID-3581 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > A user has a 4 node Cluster and would like to get not only the sessionid, vdb and user but the node of the cluster that the user is connected to -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3717) Enable SNI (Server Name Indication) support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3717?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3717: ---------------------------------- Fix Version/s: 8.13 > Enable SNI (Server Name Indication) support > ------------------------------------------- > > Key: TEIID-3717 > URL: https://issues.jboss.org/browse/TEIID-3717 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > Enable SNI support -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3541) Remove the Teiid embedded kit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3541?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3541. --------------------------------- > Remove the Teiid embedded kit > ----------------------------- > > Key: TEIID-3541 > URL: https://issues.jboss.org/browse/TEIID-3541 > Project: Teiid > Issue Type: Task > Components: Embedded > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: beta2 > Fix For: 8.13 > > > There is no reason to keep a separate embedded kit supplied by Teiid. The scripts that are building the kit needs to be removed from build. > All the required jar files for the "embedded" examples will be available from the "teiid-embedded-examples". Here we need to focus on documentation, but that is separate effort -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016