From eb9b03ab488d160aee487389605941a584e6074d Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Sun, 28 Apr 2019 10:53:07 +0400 Subject: MDEV-13335 UTF8 escape wildcard LIKE match has different behavior in different collations The fix for MDEV-17064 addressed this problem. Adding tests only. --- mysql-test/include/ctype_like_escape.inc | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/include') diff --git a/mysql-test/include/ctype_like_escape.inc b/mysql-test/include/ctype_like_escape.inc index d4abc33c178..f817bc03e74 100644 --- a/mysql-test/include/ctype_like_escape.inc +++ b/mysql-test/include/ctype_like_escape.inc @@ -16,3 +16,9 @@ select c1 as c1u from t1 where c1 like 'ab\_def'; # should return ab_def select c1 as c2h from t1 where c1 like 'ab#_def' escape '#'; drop table t1; + +# +# MDEV-13335 UTF8 escape wildcard LIKE match has different behavior in different collations +# +SELECT @@collation_connection; +SELECT '\%b' LIKE '%\%'; -- cgit v1.2.1