summaryrefslogtreecommitdiff
path: root/mysql-test/r/processlist.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2015-05-08 00:34:06 +0400
committerAlexander Barkov <bar@mariadb.org>2015-05-08 00:34:06 +0400
commit91ee98a8c88d2595d903e70cd4e1824dffb9e43c (patch)
tree0ba8af945cae452ac34552cceebec19e96384d13 /mysql-test/r/processlist.result
parent0fcc350f732af1a3f3cbc97abf341e1bdde0d3e2 (diff)
downloadmariadb-git-91ee98a8c88d2595d903e70cd4e1824dffb9e43c.tar.gz
MDEV-7807 information_schema.processlist truncates queries with binary strings
Adding a new column INFORMATION_SCHEMA.PROCESSLIST.INFO_BINARY.
Diffstat (limited to 'mysql-test/r/processlist.result')
-rw-r--r--mysql-test/r/processlist.result18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/processlist.result b/mysql-test/r/processlist.result
index eb3af67c5bf..ebec6175a5b 100644
--- a/mysql-test/r/processlist.result
+++ b/mysql-test/r/processlist.result
@@ -17,3 +17,21 @@ select command, time < 5 from information_schema.processlist where id != connect
command time < 5
Sleep 1
set debug_sync='reset';
+#
+# 10.1 tests
+#
+#
+# MDEV-7807 information_schema.processlist truncates queries with binary strings
+#
+SET NAMES utf8;
+SELECT INFO, INFO_BINARY, 'xxx😎yyy' AS utf8mb4_string FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO LIKE '%xxx%yyy%';
+INFO SELECT INFO, INFO_BINARY, 'xxx????yyy' AS utf8mb4_string FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO LIKE '%xxx%yyy%'
+INFO_BINARY SELECT INFO, INFO_BINARY, 'xxx😎yyy' AS utf8mb4_string FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO LIKE '%xxx%yyy%'
+utf8mb4_string xxx😎yyy
+Warnings:
+Level Warning
+Code 1366
+Message Incorrect string value: '\xF0\x9F\x98\x8Eyy...' for column 'INFO' at row 1
+#
+# End of 10.1 tests
+#