Debian Codegraph @

mysql-test/suite/federated/optimizer.test

raw
1 #
2 #Test optimizer flags related to federated tables
3 #
4
5 --source have_federatedx.inc
6 --source include/federated.inc
7
8 connection default;
9
10 --echo #
11 --echo # MDEV-14907 FEDERATEDX doesn't respect DISTINCT
12 --echo #
13
14 CREATE TABLE t1 (
15 `foo_id` bigint(20) unsigned NOT NULL,
16 `foo_name` varchar(255) DEFAULT NULL,
17 `parent_foo_id` bigint(20) unsigned DEFAULT NULL,
18 PRIMARY KEY (`foo_id`),
19 KEY `foo_name` (`foo_name`),
20 KEY `parent_foo_id` (`parent_foo_id`)
21 ) DEFAULT CHARSET=utf8;
22
23 --replace_result $MASTER_MYPORT MASTER_PORT
24 eval CREATE TABLE `fed_t1` ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://[email protected]:$MASTER_MYPORT/test/t1';
25 INSERT INTO t1 VALUES (968903, 'STRING - 0', 822857);
26 INSERT INTO t1 VALUES (968953, 'STRING - 1', 822857);
27 INSERT INTO t1 VALUES (971603, 'STRING - 2', 822857);
28 INSERT INTO t1 VALUES (971803, 'STRING - 3', 822857);
29 INSERT INTO t1 VALUES (975103, 'STRING - 4', 822857);
30 INSERT INTO t1 VALUES (822857, 'STRING', NULL);
31
32 select foo_id,parent_foo_id,foo_name from t1 where parent_foo_id = 822857 or foo_name like 'STRING%';
33
34 explain
35 select foo_id,parent_foo_id,foo_name from fed_t1 where parent_foo_id = 822857 or foo_name like 'STRING%';
36 select foo_id,parent_foo_id,foo_name from fed_t1 where parent_foo_id = 822857 or foo_name like 'STRING%';
37 DROP TABLE fed_t1, t1;
38
39 source include/federated_cleanup.inc;