January 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ] Ivan Chan closed TEIID-3881. ---------------------------- Resolution: Done > time date function doesn't return value without sorting > ------------------------------------------------------- > > Key: TEIID-3881 > URL: https://issues.jboss.org/browse/TEIID-3881 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.3 > Environment: Teiid 8.12.3 and PostgreSQL 9.3.2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid-engine > > HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(), > QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function. > Not working query: > select MONTH("birth_date") as "MONTH_birth_date", > MONTH("birth_date") as "Month_Field", > "birth_date" > from "FoodmartDataSource_public"."employee" > order by "birth_date" > limit 200001 > Working query: > select MONTH("birth_date") as "MONTH_birth_date", > MONTH("birth_date") as "Month_Field", > "birth_date" > from "FoodmartDataSource_public"."employee" > order by "birth_date", "Month_Field" > limit 200001 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3889) asynch start transaction / rollback throws exception

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3889?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3889. ----------------------------------- Resolution: Done Added xa related checks to the asynch rollback and general setAutoCommit/rollback methods. > asynch start transaction / rollback throws exception > ---------------------------------------------------- > > Key: TEIID-3889 > URL: https://issues.jboss.org/browse/TEIID-3889 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > If a local transaction is requested, but no statements are issued to start it, then a asynch rollback will go to the server side and throw an exception rather than simply toggling the autocommit flag. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3889) asynch start transaction / rollback throws exception

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3889: ------------------------------------- Summary: asynch start transaction / rollback throws exception Key: TEIID-3889 URL: https://issues.jboss.org/browse/TEIID-3889 Project: Teiid Issue Type: Bug Components: JDBC Driver, Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.13, 8.12.4 If a local transaction is requested, but no statements are issued to start it, then a asynch rollback will go to the server side and throw an exception rather than simply toggling the autocommit flag. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3884) Queries with NextToken failing with NPE

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3884?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3884. --------------------------------- Fix Version/s: 8.13 Resolution: Done > Queries with NextToken failing with NPE > --------------------------------------- > > Key: TEIID-3884 > URL: https://issues.jboss.org/browse/TEIID-3884 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.13, 8.12.4 > > > Issuing the queries that return more than single page with out any system parameters are failing with NPE. Example: > {code} > http://localhost:8080/odata4/vdb.1/schema/view > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3888?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3888: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1296599 Bugzilla Update: Perform > Redshift - there is not function SUBSTR (RS uses SUBSTRING) > ----------------------------------------------------------- > > Key: TEIID-3888 > URL: https://issues.jboss.org/browse/TEIID-3888 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.3 > Environment: driver - PostgreSQL 9.2 > translator - postgresql > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Postgresql translator uses SUBSTR function to get substring of string (e.g. function LEFT(x,y)), but Redshift does not support function SUBSTR. It support SUBSTRING function instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3888: ----------------------------------- Summary: Redshift - there is not function SUBSTR (RS uses SUBSTRING) Key: TEIID-3888 URL: https://issues.jboss.org/browse/TEIID-3888 Project: Teiid Issue Type: Bug Affects Versions: 8.12.3 Environment: driver - PostgreSQL 9.2 translator - postgresql Reporter: Juraj Duráni Assignee: Steven Hawkins Postgresql translator uses SUBSTR function to get substring of string (e.g. function LEFT(x,y)), but Redshift does not support function SUBSTR. It support SUBSTRING function instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3887) Redshift - RS does not support ASCII function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3887?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3887: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1296583 Bugzilla Update: Perform > Redshift - RS does not support ASCII function > ---------------------------------------------- > > Key: TEIID-3887 > URL: https://issues.jboss.org/browse/TEIID-3887 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.3 > Environment: driver - PostgreSQL 9.2 > translator - postgresql > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Redshift database does not support ASCII function > E.g. *SELECT INTKEY, ASCII(INTKEY) FROM BQT1.SmallA ORDER BY INTKEY* is translated as *SELECT g_0.intkey AS c_0, ascii(cast(g_0.intkey AS varchar(4000))) AS c_1 FROM smalla AS g_0 ORDER BY c_0* > Result: > {code:text} > Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables. > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3887) Redshift - RS does not support ASCII function

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3887: ----------------------------------- Summary: Redshift - RS does not support ASCII function Key: TEIID-3887 URL: https://issues.jboss.org/browse/TEIID-3887 Project: Teiid Issue Type: Bug Affects Versions: 8.12.3 Environment: driver - PostgreSQL 9.2 translator - postgresql Reporter: Juraj Duráni Assignee: Steven Hawkins Redshift database does not support ASCII function E.g. *SELECT INTKEY, ASCII(INTKEY) FROM BQT1.SmallA ORDER BY INTKEY* is translated as *SELECT g_0.intkey AS c_0, ascii(cast(g_0.intkey AS varchar(4000))) AS c_1 FROM smalla AS g_0 ORDER BY c_0* Result: {code:text} Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables. {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3869) Enable Teiid to be exposed as a GIS compliant data source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3869?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3869: --------------------------------------- Looking at the current community geoserver, we should be able to act as a source with a few modifications additional spatial functions, system tables, and the pg layer. What won't work: create/drop database/table user defined types They are also referencing a postgis ng driver - but this doesn't seem related to the pgsql ng driver (which has some red hat relationship). The pgsql ng driver effectively assumes pg 9+ and uses different metadata queries, so hopefully they aren't migrating to that. > Enable Teiid to be exposed as a GIS compliant data source > --------------------------------------------------------- > > Key: TEIID-3869 > URL: https://issues.jboss.org/browse/TEIID-3869 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, OData, ODBC > Reporter: Van Halbert > Assignee: Steven Hawkins > > See > http://www.esri.com/~/media/Files/Pdfs/library/whitepapers/pdfs/supported... > WMS - http://www.opengeospatial.org/standards/wms > WFS - http://www.opengeospatial.org/standards/wfs > Using MapViewer to show maps based on WMS services. The WMS services are provided by a GeoServer like ArcGIS or GeoServer. > OData has also some capabilities in the Geo space especially on the .Net libraries side. > See http://www.odata.org/libraries/ for Microsoft.Spatial (OData v4) and System.Spatial (OData v1-3) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3886) Redshift - query ends with error message "Query cancelled on user's request"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3886?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3886: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1296547 Bugzilla Update: Perform > Redshift - query ends with error message "Query cancelled on user's request" > ---------------------------------------------------------------------------- > > Key: TEIID-3886 > URL: https://issues.jboss.org/browse/TEIID-3886 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If one query ends with PSQLException, every next query ends with exception with error message "Query cancelled on user's request". This happens even if new connection to VDB is created. > Query 1: select convert(timevalue, time) from source.smalla > Query 2: select 1 from source.smalla > Result of query 1 (see TEIID-3885): > {code:text} > 14:26:56,197 WARN [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue187) TEIID30020 Processing exception for request 0iWdE3mYfqbA.0 'TEIID30504 rs: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0]'. Originally TeiidProcessingException 'ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.' QueryExecutorImpl.java:2157.: org.teiid.core.TeiidProcessingException: TEIID30504 rs: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0] > at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:374) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40] > Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at sun.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) [:1.8.0_40] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40] > at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at com.sun.proxy.$Proxy124.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_40] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1] > ... 6 more > Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables. > 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) > ... 17 more > {code} > Result of query 2: > {code:text} > 14:35:06,805 DEBUG [org.teiid.CONNECTOR] (Worker20_QueryProcessorQueue200) Source-specific command: SELECT 1 FROM smalla AS g_0 > 14:35:06,983 WARN [org.teiid.CONNECTOR] (Worker20_QueryProcessorQueue200) Connector worker process failed for atomic-request=bD3A8iB3KL+0.3.0.48: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT 1 FROM smalla AS g_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.3.redhat-1.jar:8.12.3.redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349) > at sun.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) [:1.8.0_40] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40] > at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy124.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:266) [rt.jar:1.8.0_40] > 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:1142) [rt.jar:1.8.0_40] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40] > Caused by: org.postgresql.util.PSQLException: ERROR: Query cancelled on user's request > 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.3.redhat-1.jar:8.12.3.redhat-1] > ... 17 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2016