summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <ram@mysql.r18.ru>2003-01-03 19:46:15 +0400
committerunknown <ram@mysql.r18.ru>2003-01-03 19:46:15 +0400
commit287906e972266e9f629a8b53a7f6c46f22bac11a (patch)
treef6a69b3d1a55e968079d9efbcf01da86fe5fb48d /mysql-test
parent07eb2fc4f32f0fdf0204e524f7a7a8e50c842dd7 (diff)
downloadmariadb-git-287906e972266e9f629a8b53a7f6c46f22bac11a.tar.gz
Fix for the QUOTE() function.
BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/func_str.result3
-rw-r--r--mysql-test/t/func_str.test1
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index 69e37d7b911..9e8f2b90f07 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -155,6 +155,9 @@ quote(concat('abc\'', '\\cba'))
select quote(1/0), quote('\0\Z');
quote(1/0) quote('\0\Z')
NULL '\0\Z'
+select length(quote(concat(char(0),"test")));
+length(quote(concat(char(0),"test")))
+8
select reverse("");
reverse("")
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index 717b9c86a07..f95cd901dfb 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -64,6 +64,7 @@ select decode(encode("abcdef","monty"),"monty")="abcdef";
select quote('\'\"\\test');
select quote(concat('abc\'', '\\cba'));
select quote(1/0), quote('\0\Z');
+select length(quote(concat(char(0),"test")));
#
# Wrong usage of functions