[
https://issues.apache.org/jira/browse/TRAFODION-2229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15690825#comment-15690825
]
ASF GitHub Bot commented on TRAFODION-2229:
-------------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/849#discussion_r89365105
--- Diff: core/sql/regress/compGeneral/EXPECTED006.SB ---
@@ -1686,9 +1686,10 @@ d3d9446802a44259755d38e6d163e820 852952723
b1d5781111d84f7b3fe45a0852e59758cd
--- 1 row(s) selected.
>>select sha2('the original data', 128) from dual;
-*** ERROR[8428] The argument to function SHA2 is not valid.
+*** ERROR[4045] The operand of function SHA2 must be numeric.
--- End diff --
The error is a bit misleading, since 128 is numeric. Ideally, the error
message should say that we expect 224, 256, 384, or 512.
> add Hashing functions to Trafodion
> ----------------------------------
>
> Key: TRAFODION-2229
> URL: https://issues.apache.org/jira/browse/TRAFODION-2229
> Project: Apache Trafodion
> Issue Type: Sub-task
> Reporter: liu ming
> Assignee: liu ming
> Fix For: 2.1-incubating
>
>
> CRC32() Compute a cyclic redundancy check value
> MD5() Calculate MD5 checksum
> SHA1(), SHA() Calculate an SHA-1 160-bit checksum
> SHA2() Calculate an SHA-2 checksum
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)