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 commented on TEIID-3881: ---------------------------------- It seems like I made a mistake on my side. Sorry about it. Closing this issue now. Thanks for looking. > 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)

10 years, 2 months

1
0
0 / 0

[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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 months

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)

10 years, 2 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 January 2016