summaryrefslogtreecommitdiff
path: root/mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test')
-rw-r--r--mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test b/mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test
new file mode 100644
index 00000000000..1ed8be2196b
--- /dev/null
+++ b/mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test
@@ -0,0 +1,11 @@
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+
+create table t (a int not null);
+insert into t values (1),(2),(3);
+
+SELECT SQL_NO_FCACHE SLEEP(0);
+SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM t;
+
+DROP TABLE t;