1 files changed, 36 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/cluster_filter_key.test b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_key.test
new file mode 100644
index 00000000000..dfe1756ada7
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_key.test
@@ -0,0 +1,36 @@
+#--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 (a));
+insert into t1 values (1,"10",100);
+insert into t1 values (2,"20",200);
+insert into t1 values (3,"30",300);
+insert into t1 values (4,"40",400);
+insert into t1 values (5,"50",500);
+
+explain select * from t1 where a > 2;
+select * from t1 where a > 2;
+select b from t1 where a > 2;
+select c from t1 where a > 2;
+
+#explain delete from t1 where a <2;
+delete from t1 where a <2;
+
+explain select * from t1 where a >= 4;
+select * from t1 where a >= 4;
+select b from t1 where a >= 4;
+select c from t1 where a >= 4;
+
+update t1 set c = c+1000;
+explain select * from t1 where a >= 4;
+select * from t1 where a >= 4;
+select b from t1 where a >= 4;
+select c from t1 where a >= 4;
+
+
+DROP TABLE t1;