November 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3375) Support Kerberos handshake for mutual auth

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3375?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3375. --------------------------------- > Support Kerberos handshake for mutual auth > ------------------------------------------ > > Key: TEIID-3375 > URL: https://issues.jboss.org/browse/TEIID-3375 > Project: Teiid > Issue Type: Feature Request > Components: Embedded, ODBC > Affects Versions: 8.9.1 > Environment: Postgres JDBC 9.4-1201 client on Windows 7, Teiid server on either Windows 7 or RHEL Linux 2.6 (behaved same on both platforms). > Reporter: Ben Kibler > Assignee: Ramesh Reddy > Fix For: 8.11, 8.7.2.6_2, 8.7.6 > > > When using Teiid Embedded with Kerberos, the GSS handshake with the Postgres JDBC client is failing while trying to establish mutual authentication. > The ODBCRemoteServerImpl.login() method should send both an AuthenticationGSSContinue and AuthenticationOk message when the client is requesting mutual authentication. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3771. --------------------------------- > Teiid throws an NPE while executing query with nested subquery IN predicate > --------------------------------------------------------------------------- > > Key: TEIID-3771 > URL: https://issues.jboss.org/browse/TEIID-3771 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.1 > > > Teiid throws an NPE while executing query with double IN predicate. Example query: > SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM)) -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4290) Rollback to savepoint should be a no op

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4290?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4290. --------------------------------- > Rollback to savepoint should be a no op > --------------------------------------- > > Key: TEIID-4290 > URL: https://issues.jboss.org/browse/TEIID-4290 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.13.6, 9.0.1 > > > Save points are not supported and the creation of a save point by an ODBC client is effectively ignored, but the rollback is treated as a full rollback of the transaction. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4331. --------------------------------- > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.x > Reporter: Tom Johnston > Assignee: Steven Hawkins > Fix For: 9.1 > > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4200. --------------------------------- > Provide support for Wildfly 10 > ------------------------------ > > Key: TEIID-4200 > URL: https://issues.jboss.org/browse/TEIID-4200 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Labels: Alpha1 > Fix For: 9.1 > > > Upgrade the host runtime environment for Teiid Server to be WildFly 10. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4301) Migration Guide From Teiid 8.x: Java versions swapped?

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4301?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4301. --------------------------------- > Migration Guide From Teiid 8.x: Java versions swapped? > ------------------------------------------------------- > > Key: TEIID-4301 > URL: https://issues.jboss.org/browse/TEIID-4301 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Affects Versions: 8.13.x > Reporter: Scott Seaton > Assignee: Steven Hawkins > Priority: Trivial > Fix For: 9.0 > > > Looks like the Java 1.7/1.8 versions may be swapped in this documentation: > https://teiid.gitbooks.io/documents/content/admin/Migration_Guide_From_Te... > JRE Support > Teiid 9.1 uses WildFly 10.0.0. Both the server kit and usage of Teiid Embedded will require Java 1.7+. The client driver may still use a 1.6 runtime. > Teiid 9.0 uses WildFly 9.0.2. Both the server kit and usage of Teiid Embedded will require Java 1.8+. The client driver may still use a 1.6 runtime. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4312) INNER and LEFT joins of CTEs fail or return incorrect results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4312?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4312. --------------------------------- > INNER and LEFT joins of CTEs fail or return incorrect results > ------------------------------------------------------------- > > Key: TEIID-4312 > URL: https://issues.jboss.org/browse/TEIID-4312 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.0 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.1 > > > I defined a table "test_a" with the same data and structure in PostgreSQL and MySQL: > {code:sql} > CREATE TABLE test_a(a integer, b integer); > INSERT INTO test_a VALUES (1, 1); > INSERT INTO test_a VALUES (1, 2); > INSERT INTO test_a VALUES (2, 1); > INSERT INTO test_a VALUES (2, 2); > INSERT INTO test_a VALUES (3, 2); > INSERT INTO test_a VALUES (3, 10); > {code} > The following query, based on the table in *PostgreSQL*, fails: > {code:sql} > with > CTE1 as ( > WITH > CTE11 as (SELECT a from pg.test_a), > CTE21 as (select t1.a from CTE11 t1 join CTE11 t2 on t1.a=t2.a), > CTE31 as (select a from CTE21) > SELECT CTE31.a FROM CTE21 join CTE31 on CTE31.a=CTE21.a > ) > select * from CTE1 > {code} > with this exception: > {code:sql} > 16:36:28,752 WARN [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue114) eYLiZgMIChSF Connector worker process failed for atomic-request=eYLiZgMIChSF.11.2.24: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH CTE11 (a) AS (SELECT NULL FROM "public"."test_a" AS g_0), CTE21 (a) AS (SELECT g_0.a FROM CTE11 AS g_0, CTE11 AS g_1 WHERE g_0.a = g_1.a) SELECT g_1.a FROM CTE21 AS g_0, CTE21 AS g_1 WHERE g_1.a = g_0.a] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:365) > at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy56.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > 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) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.postgresql.util.PSQLException: ERROR: failed to find conversion function from unknown to text > 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:504) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) > ... 17 more > {code} > The same query based on the table in *MySQL* wrongly returns an empty result. > The main differences is that the query is fully pushed down to PostgreSQL but it isn't in MySQL. > Regarding wrong results, I am also experiencing a similar problem with the following query: > {code:sql} > with > CTE1 as ( > WITH > alias as (SELECT a from pg.test_a), > alias2 as (select t2.a as a1, t1.a from alias t1 join (SELECT 1 as a) t2 on t1.a=t2.a), > CTE31 as (select t2.a as a1 from alias2 t2) > SELECT CTE31.a1 FROM alias2 join CTE31 on CTE31.a1=alias2.a > ), > CTE2 as ( > WITH > alias as (SELECT 1 as a), > alias2 as (select t2.a a1, t1.a from alias t1 join (SELECT 1 as a) t2 on t1.a=t2.a), > CTE32 as (select t2.a from alias2 t2) > SELECT CTE32.a FROM alias2 join CTE32 on CTE32.a=alias2.a > ) > select * from CTE1 as T1 join CTE2 as T2 on T1.a1=T2.a > {code} > It returns 4 rows (as expected) if based on MySQL table but it returns 16 rows if pushed down to PostgreSQL. > I don't know if the two behaviors are related or not, but I can create a different ticket for the second issue, if needed. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4281) MySQL translator should warn about useCursorFetch

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4281?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4281. --------------------------------- > MySQL translator should warn about useCursorFetch > ------------------------------------------------- > > Key: TEIID-4281 > URL: https://issues.jboss.org/browse/TEIID-4281 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > The docs appear to have accidentally dropped the warning about using cursor fetch for mysql. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4305) message key overrode for TEIID-3811

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4305?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4305. --------------------------------- > message key overrode for TEIID-3811 > ----------------------------------- > > Key: TEIID-4305 > URL: https://issues.jboss.org/browse/TEIID-4305 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.12.2, 8.13 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > TEIID-3811 mistakenly overrode TEIID20036 in the properties file - TEIID20037 should be used instead. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4191) Add a NOQUOTE option for the TEXTAGG function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4191?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4191. --------------------------------- > Add a NOQUOTE option for the TEXTAGG function > --------------------------------------------- > > Key: TEIID-4191 > URL: https://issues.jboss.org/browse/TEIID-4191 > Project: Teiid > Issue Type: Feature Request > Components: Grammar, Server > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1 > > > Currently on the TEXTAGG function it defaults to double quotes(") and you can specify something else with QUOTE, but there is not a way to have NO QUOTES at all. Can this be added? -- This message was sent by Atlassian JIRA (v7.2.2#72004)

9 years, 5 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2016