summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_utf8.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/partition_utf8.test')
-rw-r--r--mysql-test/main/partition_utf8.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/partition_utf8.test b/mysql-test/main/partition_utf8.test
index 65050429a52..9bfa352ab25 100644
--- a/mysql-test/main/partition_utf8.test
+++ b/mysql-test/main/partition_utf8.test
@@ -62,3 +62,22 @@ CREATE OR REPLACE TABLE t1 (a TIME)
--echo #
--echo # End of 10.3 tests
--echo #
+
+--echo #
+--echo # Start of 10.5 tests
+--echo #
+
+--echo #
+--echo # MDEV-20856 Bad values in metadata views for partitions on VARBINARY
+--echo #
+
+CREATE TABLE t1 (a VARBINARY(10)) CHARACTER SET utf8
+ PARTITION BY LIST COLUMNS (a) (PARTITION p0 VALUES IN (0xFF));
+SHOW CREATE TABLE t1;
+SELECT PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='t1';
+DROP TABLE t1;
+
+
+--echo #
+--echo # End of 10.5 tests
+--echo #