summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <evgen@moonbone.local>2007-01-12 16:43:52 +0300
committerunknown <evgen@moonbone.local>2007-01-12 16:43:52 +0300
commitcb96e8bcd8e4593929e2f1226468097963b5a793 (patch)
tree73dbb4bdf18a95157622cc3458f0541da6215366 /mysql-test/t/func_str.test
parent0f0d0f5bd45ef87ff75bc15c3faac8d9cb97c154 (diff)
parent52c100ae0cfbf5588fe3fa1917aba3934241e3f6 (diff)
downloadmariadb-git-cb96e8bcd8e4593929e2f1226468097963b5a793.tar.gz
Merge moonbone.local:/work/latest-4.1-opt-mysql
into moonbone.local:/work/latest-5.0-opt-mysql mysql-test/t/func_str.test: Auto merged sql/item_strfunc.cc: Auto merged sql/item_strfunc.h: Auto merged sql/sql_delete.cc: Auto merged mysql-test/r/delete.result: Manual merge mysql-test/r/func_str.result: Manual merge mysql-test/t/delete.test: Manual merge
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r--mysql-test/t/func_str.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index a55b633b91e..64b59025d44 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -730,6 +730,14 @@ EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(BOTH 'y' FROM s) > 'ab';
DROP TABLE t1;
+#
+# Bug#23409: ENCODE() and DECODE() functions aren't printed correctly
+#
+create table t1(f1 varchar(4));
+explain extended select encode(f1,'zxcv') as 'enc' from t1;
+explain extended select decode(f1,'zxcv') as 'enc' from t1;
+drop table t1;
+
--echo End of 4.1 tests
#