1 files changed, 22 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/cluster_filter_varchar_prefix.test b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_varchar_prefix.test
new file mode 100644
index 00000000000..8fb4f20eeb1
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_varchar_prefix.test
@@ -0,0 +1,22 @@
+#--source include/have_tokudb.inc
+SET DEFAULT_STORAGE_ENGINE='tokudb';
+--echo *** Bug #22169 ***
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+create table t1 (a int, b varchar(20), c int, key (b(3)) clustering=yes);
+insert into t1 values (1,"100000",100);
+insert into t1 values (2,"200000",200);
+insert into t1 values (3,"300000",300);
+insert into t1 values (4,"400000",400);
+insert into t1 values (5,"500000",500);
+
+select b from t1 where b > "10";
+
+alter table t1 drop key b;
+alter table t1 add key b(b(2)) clustering=yes;
+select b from t1 where b > "10";
+
+DROP TABLE t1;