diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-06-10 12:32:20 +0400 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
| commit | ca8950cc1149d219e4c322f6489145b12250ad8d (patch) | |
| tree | b1f0455f38227d91e679f55197fa343a2acd08ea /mysql-test/r/func_compress.result | |
| parent | f9cdc748512325e8d77810c77f204eaf69854282 (diff) | |
| download | mariadb-git-ca8950cc1149d219e4c322f6489145b12250ad8d.tar.gz | |
More test for MDEV-10134 Add full support for DEFAULT
CRC32(), MD5(), FROM_BASE64(), TO_BASE64(), HEX(), UNHEX(),
ENCODE(), DECODE(), PASSWORD(),
COMPRESS(), UNCOMPRESS(), UNCOMPRESSED_LENGTH().
Diffstat (limited to 'mysql-test/r/func_compress.result')
| -rw-r--r-- | mysql-test/r/func_compress.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result index 9bedddd7740..7f5208c67f6 100644 --- a/mysql-test/r/func_compress.result +++ b/mysql-test/r/func_compress.result @@ -167,3 +167,18 @@ set global max_allowed_packet=default; # # End of 5.5 tests # +# +# Start of 10.2 tests +# +# +# MDEV-10134 Add full support for DEFAULT +# +CREATE TABLE t1 (a TEXT, b BLOB DEFAULT COMPRESS(a), bl INT DEFAULT UNCOMPRESSED_LENGTH(b), a1 TEXT DEFAULT UNCOMPRESS(b)); +INSERT INTO t1 (a) VALUES (REPEAT('a',100)); +SELECT bl, a1 FROM t1; +bl a1 +100 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa +DROP TABLE t1; +# +# End of 10.2 tests +# |