| 1 |
SET GLOBAL query_cache_size= 16*1024*1024; |
| 2 |
SET GLOBAL query_cache_type= 1; |
| 3 |
CREATE TABLE t1 (i INT); |
| 4 |
CREATE TABLE t2 (i INT) ENGINE=FEDERATED CONNECTION="mysql://root@localhost:MASTER_MYPORT/test/t1"; |
| 5 |
ALTER TABLE t2 DISABLE KEYS; |
| 6 |
ERROR HY000: Storage engine FEDERATED of the table `test`.`t2` doesn't have this option |
| 7 |
CREATE TABLE t3 (i INT) ENGINE=FEDERATED CONNECTION="mysql://root@localhost:MASTER_MYPORT/test/t1"; |
| 8 |
# restart |
| 9 |
SET GLOBAL query_cache_size= default; |
| 10 |
SET GLOBAL query_cache_type= default; |
| 11 |
drop table t1, t2, t3; |