Support Encryption and Compression Functions

[shenli]

List of Functions

• AES_DECRYPT() Decrypt using AES
• AES_ENCRYPT() Encrypt using AES
• COMPRESS() Return result as a binary string
• DECODE() Decodes a string encrypted using ENCODE()
• ENCODE() Encode a string
• MD5() Calculate MD5 checksum
• PASSWORD() (deprecated 5.7.6) Calculate and return a password string
• RANDOM_BYTES() Return a random byte vector
• SHA1(), SHA() Calculate an SHA-1 160-bit checksum
• SHA2() Calculate an SHA-2 checksum
• UNCOMPRESS() Uncompress a string compressed
• UNCOMPRESSED_LENGTH() Return the length of a string before compression
• VALIDATE_PASSWORD_STRENGTH() Determine strength of password Support password validation #9741

Removed in MySQL 8.0, will not add:

• DES_DECRYPT() (deprecated 5.7.6) Decrypt a string
• DES_ENCRYPT() (deprecated 5.7.6) Encrypt a string
• OLD_PASSWORD() Return the value of the pre-4.1 implementation of PASSWORD
• ENCRYPT() (deprecated 5.7.6) Encrypt a string Function encrypt not supported #4025

MySQL Enterprise Edition functions, not required to add:

• ASYMMETRIC_DECRYPT() Decrypt ciphertext using private or public key
• ASYMMETRIC_DERIVE() Derive symmetric key from asymmetric keys
• ASYMMETRIC_ENCRYPT() Encrypt cleartext using private or public key
• ASYMMETRIC_SIGN() Generate signature from digest
• ASYMMETRIC_VERIFY() Verify that signature matches digest
• CREATE_ASYMMETRIC_PRIV_KEY() Create private key
• CREATE_ASYMMETRIC_PUB_KEY() Create public key
• CREATE_DH_PARAMETERS() Generate shared DH secret
• CREATE_DIGEST() Generate digest from string

[morgo]

There is a separate issue open for password validation, so I am going to close this now. Everything else has been implemented.