summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_regexp.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/func_regexp.test')
-rw-r--r--mysql-test/t/func_regexp.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/func_regexp.test b/mysql-test/t/func_regexp.test
index 638e0bf08ee..d0ab0cc9044 100644
--- a/mysql-test/t/func_regexp.test
+++ b/mysql-test/t/func_regexp.test
@@ -92,3 +92,15 @@ DROP TABLE t1;
--echo End of 5.1 tests
+
+#
+# MDEV-5820 MySQL Bug #54805 definitions in regex/my_regex.h conflict with /usr/include/regex.h
+# Bug #55427 REGEXP does not recognize '\t' as [:blank:]
+#
+# Test that \t is indeed recognized as [[:blank:]]
+#
+SELECT ' ' REGEXP '[[:blank:]]';
+SELECT '\t' REGEXP '[[:blank:]]';
+
+SELECT ' ' REGEXP '[[:space:]]';
+SELECT '\t' REGEXP '[[:space:]]';