[
https://issues.apache.org/jira/browse/TRAFODION-2559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15946071#comment-15946071
]
David Wayne Birdsall commented on TRAFODION-2559:
-------------------------------------------------
Debugging this, I notice that for UTF-8, we don't generate PCODE for the SUBSTR
operation (which RIGHT is a syntactic sugar for), while for ISO88591 we do.
Just for fun, I set an environment variable "export NO_PCODE=1" then re-entered
sqlci. In debug builds, this turns PCODE generation off. When I do this, I see
the bad behavior with ISO88591 strings as well. So, evidently the bug is in the
eval method for SUBSTRING.
> 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)
