robertamarton commented on a change in pull request #1825: [TRAFODION-3293] Add the AES_ENCRYPT Function in the Trafodion SQL Reference Manual URL: https://github.com/apache/trafodion/pull/1825#discussion_r272750973
########## File path: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ########## @@ -487,6 +487,141 @@ LARGEINT if the precision of the argument is greater than or equal to ABS (-20 + 12) ``` +<<< +[[aes_encrypt_function]] +== AES_ENCRYPT Function + +The AES_ENCRYPT function encrypts a `_string_` using a specified encryption `_key_` with the AES (Advanced Encryption Standard) algorithm and returns a binary string. + +This function prevents sensitive data from being visible to the public. For example, use the AES_ENCRYPT function to encrypt person identity number to preserve user confidentiality. + +`AES_ENCRYPT (_string_, _key_)` + +[[syntax_description_of_aes_encrypt]] +=== Syntax Description of AES_ENCRYPT + +* `_string_` ++ +is the data to be encrypted. + +* `_key_` ++ +is the encryption key to encrypt the `_string_`. Review comment: Later you give an example on using a cryptographic hash function to encrypt the key. Perhaps you can mention it here -> "key" can be hashed using a cryptographic hash functions such as SHA1 and MD5. Do you know what cryptographic functions can be specified? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
