summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_digest.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-10 14:09:05 +0400
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit8f226121e52cbaa332964b24bd27e8babf9f2b06 (patch)
tree34a1fdb45dccb16557724a81e00a93a41dfd4f6f /mysql-test/r/func_digest.result
parentca8950cc1149d219e4c322f6489145b12250ad8d (diff)
downloadmariadb-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.result19
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
+#