diff options
author | Alexander Barkov <bar@mariadb.org> | 2016-06-10 14:09:05 +0400 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
commit | 8f226121e52cbaa332964b24bd27e8babf9f2b06 (patch) | |
tree | 34a1fdb45dccb16557724a81e00a93a41dfd4f6f /mysql-test/r/func_digest.result | |
parent | ca8950cc1149d219e4c322f6489145b12250ad8d (diff) | |
download | mariadb-git-8f226121e52cbaa332964b24bd27e8babf9f2b06.tar.gz |
More test for MDEV-10134 Add full support for DEFAULT
ENCRYPT(), SHA(), SHA2(),
AES_ENCRYPT(), AES_DECRYPT(),
DES_ENCRYPT(), DES_DECRYPT()
Diffstat (limited to 'mysql-test/r/func_digest.result')
-rw-r--r-- | mysql-test/r/func_digest.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/func_digest.result b/mysql-test/r/func_digest.result index 35746157d6e..6d1fe17c0da 100644 --- a/mysql-test/r/func_digest.result +++ b/mysql-test/r/func_digest.result @@ -1426,3 +1426,22 @@ Catalog Database Table Table_alias Column Column_alias Type Length Max length Is def sha2('1',224) 253 56 56 Y 0 39 8 sha2('1',224) e25388fde8290dc286a6164fa2d97e551b53498dcbf7bc378eb1f178 +# +# Start of 10.2 tests +# +# +# MDEV-10134 Add full support for DEFAULT +# +CREATE TABLE t1 ( +a VARCHAR(30), +b TEXT DEFAULT SHA(a), +c TEXT DEFAULT SHA2(a,224) +); +INSERT INTO t1 (a) VALUES ('abc'); +SELECT * FROM t1; +a b c +abc a9993e364706816aba3e25717850c26c9cd0d89d 23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7 +DROP TABLE t1; +# +# End of 10.2 tests +# |