May 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3474: ---------------------------------- Fix Version/s: 8.11 Affects Version/s: 7.7 (was: 8.7.1.6_2) Component/s: JDBC Connector > Inconsistent results of RIGHT function for different datasources > ---------------------------------------------------------------- > > Key: TEIID-3474 > URL: https://issues.jboss.org/browse/TEIID-3474 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.7 > Environment: OS: Fedora 20 > arch: x86_64 > java: oracle 1.8 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > > The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. > ======= > +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ > *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* > 0 0 > 1 1 > 2 2 > ... > 10 0 > 11 1 > ... > 100 0 > 101 1 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " > ===== > +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ > *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* > 0 0 > 1 1 > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Oracle:* > 0 <null> > 1 <null> > 2 <null> > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3474: --------------------------------------- Yes, that was my mistake. I didn't see that the padding was determined by the type, rather than the value (which is different behavior than others, such as H2). > Inconsistent results of RIGHT function for different datasources > ---------------------------------------------------------------- > > Key: TEIID-3474 > URL: https://issues.jboss.org/browse/TEIID-3474 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: OS: Fedora 20 > arch: x86_64 > java: oracle 1.8 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. > ======= > +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ > *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* > 0 0 > 1 1 > 2 2 > ... > 10 0 > 11 1 > ... > 100 0 > 101 1 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " > ===== > +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ > *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* > 0 0 > 1 1 > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Oracle:* > 0 <null> > 1 <null> > 2 <null> > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3473) Selecting RAW(16) column via OData errors

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3473?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3473: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1220909, https://bugzilla.redhat.com/show_bug.cgi?id=1221193 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1220909) > Selecting RAW(16) column via OData errors > ----------------------------------------- > > Key: TEIID-3473 > URL: https://issues.jboss.org/browse/TEIID-3473 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11 > > > When selecting a RAW(16) column via OData, a runtime error is thrown w/ the following message: > http://superdrake:8080/odata/Medbus/reqtracking.query?$format=json > { > "error": { > "code" : "ServerErrorException", > "message": { > "lang": "en-US", > "value": "[B cannot be cast to org.teiid.core.types.BinaryType" > } > } > } -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3474: ------------------------------------- DB2 - If you use "char(integerValue)" the result will have fixed length. That is expected behavior according to DB2 documentation [1]. But function "varchar(integerValue)" returns "usable" result [2]. [1] - http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.lu... [2] - http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.lu... > Inconsistent results of RIGHT function for different datasources > ---------------------------------------------------------------- > > Key: TEIID-3474 > URL: https://issues.jboss.org/browse/TEIID-3474 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: OS: Fedora 20 > arch: x86_64 > java: oracle 1.8 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. > ======= > +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ > *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* > 0 0 > 1 1 > 2 2 > ... > 10 0 > 11 1 > ... > 100 0 > 101 1 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " > ===== > +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ > *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* > 0 0 > 1 1 > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Oracle:* > 0 <null> > 1 <null> > 2 <null> > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3474: --------------------------------------- Postgres - this is a bug in our compensation. We assume that the same logic that basically works for oracle, will work for postgresql. This is not true as pg doesn't like negative indexes in the substr function. We'll also update the logic so that when the source is version 9.1 and above, we'll use the right function directly. Oracle - the negative indexing is apparently allowed to go beyond the first character, so we get null/empty results for strings that as smaller than the count. This will be addressed as well. DB2 - this is a bug in DB2. Left with a char cast works just fine, as does right without a cast, but using right(char(val), count) just produces the wrong result. So we'll have to workaround that on our side. > Inconsistent results of RIGHT function for different datasources > ---------------------------------------------------------------- > > Key: TEIID-3474 > URL: https://issues.jboss.org/browse/TEIID-3474 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: OS: Fedora 20 > arch: x86_64 > java: oracle 1.8 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. > ======= > +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ > *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* > 0 0 > 1 1 > 2 2 > ... > 10 0 > 11 1 > ... > 100 0 > 101 1 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " > ===== > +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ > *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* > 0 0 > 1 1 > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Oracle:* > 0 <null> > 1 <null> > 2 <null> > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3475) Add a separate example module for embedded examples

by Kylin Soong (JIRA)

Kylin Soong created TEIID-3475: ---------------------------------- Summary: Add a separate example module for embedded examples Key: TEIID-3475 URL: https://issues.jboss.org/browse/TEIID-3475 Project: Teiid Issue Type: Feature Request Components: Embedded Affects Versions: 8.11 Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 8.11 Add a separate example module for embedded examples, it will contain a runnable jar, which will load all available examples, it will also contain transaction manager, etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3473) Selecting RAW(16) column via OData errors

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3473?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3473: ------------------------------- Fix Version/s: 8.7.1.6_2 > Selecting RAW(16) column via OData errors > ----------------------------------------- > > Key: TEIID-3473 > URL: https://issues.jboss.org/browse/TEIID-3473 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11 > > > When selecting a RAW(16) column via OData, a runtime error is thrown w/ the following message: > http://superdrake:8080/odata/Medbus/reqtracking.query?$format=json > { > "error": { > "code" : "ServerErrorException", > "message": { > "lang": "en-US", > "value": "[B cannot be cast to org.teiid.core.types.BinaryType" > } > } > } -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3368) The database-service.jar needs version version in its name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3368?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3368: ------------------------------------------------ Alex Szczuczko <aszczucz(a)redhat.com> changed the Status of [bug 1199048|https://bugzilla.redhat.com/show_bug.cgi?id=1199048] from ASSIGNED to MODIFIED > The database-service.jar needs version version in its name > ---------------------------------------------------------- > > Key: TEIID-3368 > URL: https://issues.jboss.org/browse/TEIID-3368 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1, 8.11 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.10 > > > The database-service.jar in the tepid-extensions needs to be built with a version in the name. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3474: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1221051 > Inconsistent results of RIGHT function for different datasources > ---------------------------------------------------------------- > > Key: TEIID-3474 > URL: https://issues.jboss.org/browse/TEIID-3474 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: OS: Fedora 20 > arch: x86_64 > java: oracle 1.8 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. > ======= > +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ > *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* > 0 0 > 1 1 > 2 2 > ... > 10 0 > 11 1 > ... > 100 0 > 101 1 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " > ===== > +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ > *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* > 0 0 > 1 1 > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Oracle:* > 0 <null> > 1 <null> > 2 <null> > ... > 10 10 > 11 11 > ... > 100 00 > 101 01 > *Postgres:* > 0 0 > 1 1 > 2 2 > ... > 10 10 > 11 11 > ... > 100 100 > 101 101 > *DB2:* > 0 " " > 1 " " > 2 " " > ... > 10 " " > 11 " " > ... > 100 " " > 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3474) Inconsistent results of RIGHT function for different datasources

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3474: ----------------------------------- Summary: Inconsistent results of RIGHT function for different datasources Key: TEIID-3474 URL: https://issues.jboss.org/browse/TEIID-3474 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1.6_2 Environment: OS: Fedora 20 arch: x86_64 java: oracle 1.8 Reporter: Juraj Duráni Assignee: Steven Hawkins The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function. ======= +*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*+ *Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):* 0 0 1 1 2 2 ... 10 0 11 1 ... 100 0 101 1 *Postgres:* 0 0 1 1 2 2 ... 10 10 11 11 ... 100 100 101 101 *DB2:* 0 " " 1 " " 2 " " ... 10 " " 11 " " ... 100 " " 101 " " ===== +*Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey*+ *SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):* 0 0 1 1 ... 10 10 11 11 ... 100 00 101 01 *Oracle:* 0 <null> 1 <null> 2 <null> ... 10 10 11 11 ... 100 00 101 01 *Postgres:* 0 0 1 1 2 2 ... 10 10 11 11 ... 100 100 101 101 *DB2:* 0 " " 1 " " 2 " " ... 10 " " 11 " " ... 100 " " 101 " " -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 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 May 2015