[
https://issues.apache.org/jira/browse/TRAFODION-2559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15946257#comment-15946257
]
David Wayne Birdsall commented on TRAFODION-2559:
-------------------------------------------------
I'm unable to find a recent enough version of the ANSI SQL standard. (The
latest one available to me is SQL-2003, and the RIGHT function is not present
there.) Looking at Microsoft (TM)'s documentation for Transaction SQL, their
implementation returns the whole string when the length is longer than the
string. So, adding a CASE statement to check for a length longer than the
string indeed seems like the correct semantic.
> 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)
