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

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