November 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3814) Rest Web Service URL for VDB

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3814?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-3814: ----------------------------------- Assignee: Ramesh Reddy > Rest Web Service URL for VDB > ---------------------------- > > Key: TEIID-3814 > URL: https://issues.jboss.org/browse/TEIID-3814 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.4 > Environment: JBoss Developer Studio 9.0.0 GA > Teeid 8.12 > Reporter: Mirco Marchitiello > Assignee: Ramesh Reddy > Priority: Minor > > Exposing a Teiid Procedure as Rest Service the url, as defined in > https://docs.jboss.org/author/display/teiid812final/REST+Service+Through+VDB as > http://{host}:8080/sample_1/view/g1/123 > "view" must be in lower case in order to be accepted, even if it is been created with capital letters. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3814) Rest Web Service URL for VDB

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3814?page=com.atlassian.jira.plugin... ] Ramesh Reddy moved TEIIDDES-2717 to TEIID-3814: ----------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-3814 (was: TEIIDDES-2717) Affects Version/s: 8.4 (was: 9.0) > Rest Web Service URL for VDB > ---------------------------- > > Key: TEIID-3814 > URL: https://issues.jboss.org/browse/TEIID-3814 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.4 > Environment: JBoss Developer Studio 9.0.0 GA > Teeid 8.12 > Reporter: Mirco Marchitiello > Priority: Minor > > Exposing a Teiid Procedure as Rest Service the url, as defined in > https://docs.jboss.org/author/display/teiid812final/REST+Service+Through+VDB as > http://{host}:8080/sample_1/view/g1/123 > "view" must be in lower case in order to be accepted, even if it is been created with capital letters. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3813) Informix translator - convert function in definition of view is not pushed down

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3813?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3813: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1279400 Bugzilla Update: Perform > Informix translator - convert function in definition of view is not pushed down > ------------------------------------------------------------------------------- > > Key: TEIID-3813 > URL: https://issues.jboss.org/browse/TEIID-3813 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > I defined a view (see definition below). When I try to select all rows from the view, teiid/informix jdbc driver throws an exception. > Teiid DDL: > {code:sql} > CREATE VIEW U6 (StringCol string, > IntCol integer) > AS > SELECT CONVERT(BQT1.SmallA.IntNum, string) AS StringCol, BQT1.SmallA.IntNum AS IntCol > FROM BQT1.SmallA > UNION ALL > SELECT BQT1.SmallB.StringNum, CONVERT(BQT1.SmallB.StringNum, integer) > FROM BQT1.SmallB; > } > {code} > Query: > {code:sql} > SELECT * FROM VQT.U6 > {code} > Source-specific query > {code:sql} > SELECT g_1.intnum AS c_0, g_1.intnum AS c_1 FROM smalla AS g_1 UNION ALL SELECT g_0.stringnum AS c_0, g_0.stringnum AS c_1 FROM smallb AS g_0 > {code} > Actual exception: > {code:text} > Caused by: java.sql.SQLException: The statement failed because corresponding column data types must be compatible for each UNION, INTERSECT, or MINUS query. > at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) > at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3178) > ... > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3813) Informix translator - convert function in definition of view is not pushed down

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3813: ----------------------------------- Summary: Informix translator - convert function in definition of view is not pushed down Key: TEIID-3813 URL: https://issues.jboss.org/browse/TEIID-3813 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1.6_2 Reporter: Juraj Duráni Assignee: Steven Hawkins I defined a view (see definition below). When I try to select all rows from the view, teiid/informix jdbc driver throws an exception. Teiid DDL: {code:sql} CREATE VIEW U6 (StringCol string, IntCol integer) AS SELECT CONVERT(BQT1.SmallA.IntNum, string) AS StringCol, BQT1.SmallA.IntNum AS IntCol FROM BQT1.SmallA UNION ALL SELECT BQT1.SmallB.StringNum, CONVERT(BQT1.SmallB.StringNum, integer) FROM BQT1.SmallB; } {code} Query: {code:sql} SELECT * FROM VQT.U6 {code} Source-specific query {code:sql} SELECT g_1.intnum AS c_0, g_1.intnum AS c_1 FROM smalla AS g_1 UNION ALL SELECT g_0.stringnum AS c_0, g_0.stringnum AS c_1 FROM smallb AS g_0 {code} Actual exception: {code:text} Caused by: java.sql.SQLException: The statement failed because corresponding column data types must be compatible for each UNION, INTERSECT, or MINUS query. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3178) ... {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3812) HANA MIN and MAX functions not applicable on boolean

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3812?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3812: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1279399 Bugzilla Update: Perform > HANA MIN and MAX functions not applicable on boolean > ---------------------------------------------------- > > Key: TEIID-3812 > URL: https://issues.jboss.org/browse/TEIID-3812 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > SAP HANA doesn't support MIN and MAX functions for BOOLEAN type. > Compared to postgresql, which also has BOOLEAN data type, it seems inconsistent, as postgresql translator mimics MIN and MAX functions by translating them using PostgreSQL specific constructs: > min(BooleanValue) as bool_and(BooleanValue) > max(BooleanValue) as bool_or(BooleanValue) > Similar issue is with CEILING and FLOOR functions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3812) HANA MIN and MAX functions not applicable on boolean

by Jan Stastny (JIRA)

Jan Stastny created TEIID-3812: ---------------------------------- Summary: HANA MIN and MAX functions not applicable on boolean Key: TEIID-3812 URL: https://issues.jboss.org/browse/TEIID-3812 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1.6_2 Reporter: Jan Stastny Assignee: Steven Hawkins SAP HANA doesn't support MIN and MAX functions for BOOLEAN type. Compared to postgresql, which also has BOOLEAN data type, it seems inconsistent, as postgresql translator mimics MIN and MAX functions by translating them using PostgreSQL specific constructs: min(BooleanValue) as bool_and(BooleanValue) max(BooleanValue) as bool_or(BooleanValue) Similar issue is with CEILING and FLOOR functions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3811) Teiid Embedded with remote JDBC susceptible to exploit with common-collections in classpath

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3811: ------------------------------------- Summary: Teiid Embedded with remote JDBC susceptible to exploit with common-collections in classpath Key: TEIID-3811 URL: https://issues.jboss.org/browse/TEIID-3811 Project: Teiid Issue Type: Quality Risk Components: Embedded Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical This issue is to add at least a documentation note warning against - http://foxglovesecurity.com/2015/11/06/what-do-weblogic-websphere-jboss-j... While remote JDBC is not enabled by default and common-collections is not in the classpath it is possible that common-collections could be picked up from the environment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3789) Enable setting on SOLR translator for controlling timezone setting for Date and Timestamp columns

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3789?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3789: --------------------------------------- As far as I can tell all solr date information is in UTC - which we do convert literals to when sending queries. Unless there is an example of solr sending back a non-UTC date, then this is a non-issue, since the solrj conversion logic will simply convert from UTC to the Teiid server timezone which is expected. > Enable setting on SOLR translator for controlling timezone setting for Date and Timestamp columns > ------------------------------------------------------------------------------------------------- > > Key: TEIID-3789 > URL: https://issues.jboss.org/browse/TEIID-3789 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Fix For: 8.12.x > > > Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3810) Updating teiid-tools archetypes

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3810?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-3810: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Updating teiid-tools archetypes > -------------------------------- > > Key: TEIID-3810 > URL: https://issues.jboss.org/browse/TEIID-3810 > Project: Teiid > Issue Type: Task > Components: Tools > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > > Updating teiid-tools archetypes to be based on Teiid 8.12.0.Final > Adding in a docs section to be included with the jboss-as7 distribution. > Adding a default ResourceAdapter for the connector. > Adding an example ExecutionFactory unit test that provides a starting point. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3810) Updating teiid-tools archetypes

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3810?page=com.atlassian.jira.plugin... ] Work on TEIID-3810 started by Van Halbert. ------------------------------------------ > Updating teiid-tools archetypes > -------------------------------- > > Key: TEIID-3810 > URL: https://issues.jboss.org/browse/TEIID-3810 > Project: Teiid > Issue Type: Task > Components: Tools > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > > Updating teiid-tools archetypes to be based on Teiid 8.12.0.Final > Adding in a docs section to be included with the jboss-as7 distribution. > Adding a default ResourceAdapter for the connector. > Adding an example ExecutionFactory unit test that provides a starting point. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 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 November 2015