diff options
Diffstat (limited to 'mysql-test/t/func_encrypt.test')
| -rw-r--r-- | mysql-test/t/func_encrypt.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/func_encrypt.test b/mysql-test/t/func_encrypt.test index ed3e0a7b2d1..e27a2bd46d3 100644 --- a/mysql-test/t/func_encrypt.test +++ b/mysql-test/t/func_encrypt.test @@ -121,3 +121,25 @@ DROP TABLE t1; --echo # --echo # End of 10.1 tests --echo # + +--echo # +--echo # Start of 10.2 tests +--echo # + +--echo # +--echo # MDEV-10134 Add full support for DEFAULT +--echo # + +CREATE TABLE t1 ( + a VARCHAR(30), + b BLOB DEFAULT DES_ENCRYPT(a, 'passwd'), + c TEXT DEFAULT DES_DECRYPT(b, 'passwd') +); +SHOW CREATE TABLE t1; +INSERT INTO t1 (a) VALUES ('test'); +SELECT c FROM t1; +DROP TABLE t1; + +--echo # +--echo # End of 10.2 tests +--echo # |