[
https://issues.apache.org/jira/browse/TRAFODION-2559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15945965#comment-15945965
]
David Wayne Birdsall commented on TRAFODION-2559:
-------------------------------------------------
The following script demonstrates the problem:
create table test(a int, b varchar(6) character set utf8);
insert into test
values(2,'abcdef'),(4,'abcdef'),(6,'abcdef'),(7,'abcdef'),(9,'abcdef'),(12,'abcdef'),(15,'abcdef');
select * from test;
select right(b,a) from test;
When executed, the selects return:
>>select * from test;
A B
----------- ------------------------
2 abcdef
4 abcdef
6 abcdef
7 abcdef
9 abcdef
12 abcdef
15 abcdef
--- 7 row(s) selected.
>>
>>select right(b,a) from test;
(EXPR)
------------------------
ef
cdef
abcdef
abcde
abc
--- 7 row(s) selected.
The answers in the second select are incorrect when A > 6.
The problem only seems to happen with UTF-8. Using ISO88591 and UCS2, similar
scripts show the correct answers.
> RIGHT function gives incorrect answer on UTF-8 varchars sometimes
> -----------------------------------------------------------------
>
> Key: TRAFODION-2559
> URL: https://issues.apache.org/jira/browse/TRAFODION-2559
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.1-incubating, 2.2-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
