MySQL HeatWave User Guide
The following table shows supported encryption and compression functions. Encryption and compression functions are supported with variable-length columns. These functions are not supported with dictionary-encoded columns.
Table 5.6 Encryption and Compression Functions
| Name | Description |
|---|---|
COMPRESS() |
Return the result as a binary string. |
MD5() |
Calculate the MD5 checksum. Note
Deprecated as of MySQL 9.4.0 and scheduled for removal
in a future release.
|
RANDOM_BYTES() |
Return a random byte vector. |
SHA(), SHA1() |
Calculate an SHA-1 160-bit checksum. Note
Deprecated as of MySQL 9.4.0 and scheduled for removal
in a future release.
|
SHA2() |
Calculate an SHA-2 checksum. |
UNCOMPRESS() |
Uncompress a compressed string. |
UNCOMPRESSED_LENGTH() |
Return the length of a string before compression. |
Learn how to perform the following tasks: