1 files changed, 31 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/t/checkpoint_lock.test b/storage/tokudb/mysql-test/tokudb_bugs/t/checkpoint_lock.test
new file mode 100644
index 00000000000..be72c26b841
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb_bugs/t/checkpoint_lock.test
@@ -0,0 +1,31 @@
+# ticket 895 is a query optimization problem with the primary key
+
+#--source include/have_tokudb.inc
+SET DEFAULT_STORAGE_ENGINE = 'tokudb';
+set global tokudb_checkpoint_on_flush_logs=ON;
+--echo # Establish connection conn1 (user = root)
+connect (conn1,localhost,root,,);
+
+connection default;
+--sleep 2
+select DB, command, state, info from information_schema.processlist;
+flush logs;
+select DB, command, state, info from information_schema.processlist;
+
+connection conn1;
+set tokudb_checkpoint_lock=1;
+
+connection default;
+--send flush logs;
+
+connection conn1;
+--sleep 2
+select DB, command, state, info from information_schema.processlist;
+set tokudb_checkpoint_lock=0;
+
+connection default;
+--reap
+disconnect conn1;
+
+# Final cleanup.
+set global tokudb_checkpoint_on_flush_logs=OFF;