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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13067705#comment-13067705 ] 

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)