summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-03-04 23:18:54 +0100
committerunknown <serg@serg.mylan>2004-03-04 23:18:54 +0100
commit1530dd73a036d39358bc1057a471f0162894db2a (patch)
tree9b95ffe2c52174cda86a1c3cbb8ad987be1fcea2 /mysql-test/t/func_str.test
parentceacb0346d8df3f22a27ff1210411be663c3ea89 (diff)
downloadmariadb-git-1530dd73a036d39358bc1057a471f0162894db2a.tar.gz
UNHEX() function
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r--mysql-test/t/func_str.test3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index a9c2895206d..6e4fc21f4b0 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -78,6 +78,9 @@ select quote(concat('abc\'', '\\cba'));
select quote(1/0), quote('\0\Z');
select length(quote(concat(char(0),"test")));
select hex(quote(concat(char(224),char(227),char(230),char(231),char(232),char(234),char(235))));
+select unhex(hex("foobar")), hex(unhex("1234567890ABCDEF")), unhex("345678");
+select hex(unhex("1")), hex(unhex("12")), hex(unhex("123")), hex(unhex("1234")), hex(unhex("12345")), hex(unhex("123456"));
+select length(unhex(md5("abrakadabra")));
#
# Wrong usage of functions