Function encrypt not supported

[jackysp]

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

select length(encrypt('foo', 'ff')) <> 0;

2. What did you expect to see?

length(encrypt('foo', 'ff')) <> 0
1

3. What did you see instead?

ERROR 1305 (42000) at line 1: FUNCTION ENCRYPT does not exist

4. What version of TiDB are you using (tidb-server -V)?

[winkyao]

Note
The ENCRYPT() function is deprecated as of MySQL 5.7.6, will be removed in a future MySQL release, and should no longer be used. Consider using AES_ENCRYPT() instead.

See https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_encrypt

[winkyao]

see https://github.com/lattera/freebsd/blob/master/secure/lib/libcrypt/crypt-des.c, http://web.mit.edu/freebsd/head/lib/libcrypt/crypt.c
and https://en.wikipedia.org/wiki/Crypt_(C)

and http://man7.org/linux/man-pages/man3/crypt.3.html

[winkyao]

resolved the issue will use cgo, will make TiDB rely on specific platform, so the better way is port crypt function in golang, but the function is deprecated and will be removed in a future of MySQL, so it isn't a high priority issue now.

[morgo]

A followup to @winkyao's comment: this function was removed from MySQL 8.0.3.

[morgo]

This function was removed from MySQL 8.0 to prevent users from using weak crypto. I am going to close this issue for now, but we can re-consider if it becomes a blocking issue for someone.