mysql-test/suite/percona/sql_no_fcache.patch/percona_sql_no_fcache.test


1
2
3
4
5
6
7
8
9
10
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;