1 files changed, 102 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/cluster_filter_unpack_varchar.test b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_unpack_varchar.test
new file mode 100644
index 00000000000..3a30919a8ff
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb/t/cluster_filter_unpack_varchar.test
@@ -0,0 +1,102 @@
+--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 varchar(10), b varchar(255), c varchar(10), d varchar(300), e varchar(10), f varchar(20), primary key (c), key (b) clustering=yes, key (d,a) clustering=yes);
+insert into t1 values ("1","10","100","1000","10000","100000");
+insert into t1 values ("2","20","200","2000","20000","200000");
+insert into t1 values ("3","30","300","3000","30000","300000");
+insert into t1 values ("4","40","400","4000","40000","400000");
+insert into t1 values ("5","50","500","5000","50000","500000");
+
+# ignore rows column
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where c > "0";
+select * from t1;
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where b > "0";
+select * from t1 where b > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where d > "0";
+select * from t1 where d > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select a from t1 where d > "0";
+select a from t1 where d > "0";
+select e,f from t1 where c > "0";
+select e,f from t1 where b > "0";
+select e,f from t1 where d > "0";
+
+update t1 set a = a+1, b = b+10;
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where c > "0";
+select * from t1 where c > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where b > "0";
+select * from t1 where b > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where d > "0";
+select * from t1 where d > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select a from t1 where d > "0";
+select a from t1 where d > "0";
+select e,f from t1 where c > "0";
+select e,f from t1 where b > "0";
+select e,f from t1 where d > "0";
+
+delete from t1 where b > 35;
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where c > "0";
+select * from t1 where c > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where b > "0";
+select * from t1 where b > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where d > "0";
+select * from t1 where d > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select a from t1 where d > "0";
+select a from t1 where d > "0";
+select e,f from t1 where c > "0";
+select e,f from t1 where b > "0";
+select e,f from t1 where d > "0";
+
+
+alter table t1 drop index b, drop index d;
+alter table t1 add key d(d,a) clustering=yes, add key b(b) clustering=yes;
+
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where c > "0";
+select * from t1 where c > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where b > "0";
+select * from t1 where b > "0";
+
+--replace_column 7 NULL 9 NULL;
+explain select * from t1 where d > "0";
+select * from t1 where d > "0";
+
+--replace_column 4 NULL 7 NULL 9 NULL;
+explain select a from t1 where d > "0";
+select a from t1 where d > "0";
+select e,f from t1 where c > "0";
+select e,f from t1 where b > "0";
+select e,f from t1 where d > "0";
+
+
+
+DROP TABLE t1;