| 1 |
# |
| 2 |
# MDEV-12725 select on federated table crashes server |
| 3 |
# |
| 4 |
# |
| 5 |
SET GLOBAL query_cache_size= 16*1024*1024; |
| 6 |
SET GLOBAL query_cache_type= 1; |
| 7 |
CREATE TABLE t1 (i INT); |
| 8 |
--replace_result $MASTER_MYPORT MASTER_MYPORT |
| 9 |
eval CREATE TABLE t2 (i INT) ENGINE=FEDERATED CONNECTION="mysql://root@localhost:$MASTER_MYPORT/test/t1"; |
| 10 |
--error ER_ILLEGAL_HA |
| 11 |
ALTER TABLE t2 DISABLE KEYS; |
| 12 |
--replace_result $MASTER_MYPORT MASTER_MYPORT |
| 13 |
eval CREATE TABLE t3 (i INT) ENGINE=FEDERATED CONNECTION="mysql://root@localhost:$MASTER_MYPORT/test/t1"; |
| 14 |
source include/restart_mysqld.inc; |
| 15 |
SET GLOBAL query_cache_size= default; |
| 16 |
SET GLOBAL query_cache_type= default; |
| 17 |
drop table t1, t2, t3; |