[
https://issues.apache.org/jira/browse/TRAFODION-2229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15692033#comment-15692033
]
ASF GitHub Bot commented on TRAFODION-2229:
-------------------------------------------
Github user xwq commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/849#discussion_r89429871
--- 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 --
@zellerh
Can I use 8428 instead of 4045 or use yyerror('The second operand expect
224, 256, 384 or 512') to throw Internal parse error with message. I think we
don't need to add a new error code since it only used once here.
> 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)
