summaryrefslogtreecommitdiff
path: root/mysql-test/main/statistics_json.test
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2021-12-03 20:13:43 +0300
committerSergei Petrunia <psergey@askmonty.org>2022-01-19 18:10:12 +0300
commitd8d57d2c27b58323f0d8d43253ca953d2ffa8e20 (patch)
treed3a5583c391d9883fdf4995209b7380875b79131 /mysql-test/main/statistics_json.test
parent748b293c14310e3b6146a045d8f6181dfb35227b (diff)
downloadmariadb-git-d8d57d2c27b58323f0d8d43253ca953d2ffa8e20.tar.gz
MDEV-26764: JSON_HB Histograms: handle BINARY and unassigned characters
Encode such characters in hex.
Diffstat (limited to 'mysql-test/main/statistics_json.test')
-rw-r--r--mysql-test/main/statistics_json.test7
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/main/statistics_json.test b/mysql-test/main/statistics_json.test
index bcc80093891..b67df41d9ba 100644
--- a/mysql-test/main/statistics_json.test
+++ b/mysql-test/main/statistics_json.test
@@ -227,9 +227,12 @@ drop table t1;
--echo #
--echo # Another testcase: use a character that cannot be represented in utf8:
+--echo # Also, now it's testcase for:
+--echo # MDEV-26764: JSON_HB Histograms: handle BINARY and unassigned characters
--echo #
create table t1 ( a varchar(100) character set cp1251);
-insert into t1 values ( _cp1251 x'88'),( _cp1251 x'98');
+insert into t1 values ( _cp1251 x'88'),( _cp1251 x'88'), ( _cp1251 x'88');
+insert into t1 values ( _cp1251 x'98'),( _cp1251 x'98');
analyze table t1 persistent for all;
--source include/histogram_replaces.inc
@@ -237,6 +240,8 @@ select hist_type, histogram
from mysql.column_stats
where db_name=database() and table_name='t1';
+analyze select * from t1 where a=_cp1251 x'88';
+
drop table t1;
--echo #