summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_str.result
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2006-02-17 10:59:47 -0800
committerunknown <jimw@mysql.com>2006-02-17 10:59:47 -0800
commit1b587ced223f6f4d2a7d683c3062d622019c9fb8 (patch)
tree57f325a6809e5f37e0ab5611893ed0da5dd2ca62 /mysql-test/r/func_str.result
parent46c6908479aeef008527f21718629259c0440b58 (diff)
parenteae6679fd4a55a1798f2c20385507f869c85e7a6 (diff)
downloadmariadb-git-1b587ced223f6f4d2a7d683c3062d622019c9fb8.tar.gz
Merge mysql.com:/home/jimw/my/mysql-5.0-clean
into mysql.com:/home/jimw/my/mysql-5.1-clean BitKeeper/etc/ignore: auto-union mysql-test/r/func_str.result: Auto merged sql/item.cc: Auto merged sql/item.h: Auto merged sql/item_strfunc.cc: Auto merged mysql-test/t/disabled.def: Resolve conflict
Diffstat (limited to 'mysql-test/r/func_str.result')
-rw-r--r--mysql-test/r/func_str.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index 806ccf96537..f862ee29986 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -1023,3 +1023,10 @@ select format(d, 2) from t1;
format(d, 2)
NULL
drop table t1;
+create table t1 (c varchar(40));
+insert into t1 values ('y,abc'),('y,abc');
+select c, substring_index(lcase(c), @q:=',', -1) as res from t1;
+c res
+y,abc abc
+y,abc abc
+drop table t1;