加密与压缩函数
更新时间：2024-02-21
GaiaDB-X支持的函数，如下：
| 函数名 | 描述 |
|---|---|
| AES_ENCRYPT() | Encrypt using AES |
| MD5() | Calculate MD5 checksum |
| UNCOMPRESS() | Uncompress a string compressed |
| UNCOMPRESSED_LENGTH() | Return the length of a string before compression |
相比MySQL5.7，GaiaDB-X暂不支持的函数，如下
| 函数名 | 描述 |
|---|---|
| AES_DECRYPT() | Decrypt using AES |
| COMPRESS() | Return result as a binary string |
| DECODE() (deprecated) | Decode a string encrypted using ENCODE() |
| DES_DECRYPT() (deprecated) | Decrypt a string |
| DES_ENCRYPT() (deprecated) | Encrypt a string |
| ENCODE() (deprecated) | Encode a string |
| ENCRYPT() (deprecated) | Encrypt a string |
| PASSWORD() (deprecated) | 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 |
| VALIDATE_PASSWORD_STRENGTH() | Determine strength of password |