Debian Codegraph @

mysql-test/suite/federated/r/federated_bug_33962357.result

raw
1 # Bug#33962357: Improve federated tables code
2 CREATE DATABASE federated;
3 CREATE DATABASE federated;
4 DROP TABLE IF EXISTS federated.t1;
5 CREATE TABLE federated.t1 (
6 a int
7 );
8 INSERT INTO federated.t1 (a) VALUES (42);
9 SET @debug_save= @@GLOBAL.DEBUG;
10 SET @@GLOBAL.DEBUG='+d,bug33962357_simulate_null_cache';
11 CREATE SERVER fedlink
12 FOREIGN DATA WRAPPER mysql
13 OPTIONS (
14 HOST '127.0.0.1',
15 PORT SLAVE_PORT,
16 USER 'root',
17 PASSWORD '',
18 DATABASE 'federated');
19 DROP TABLE IF EXISTS federated.t1;
20 CREATE TABLE federated.t1 (
21 a int
22 ) ENGINE="FEDERATED"
23 CONNECTION='fedlink/t1';
24 ERROR HY000: server name: 'fedlink' doesn't exist!
25 SELECT * FROM federated.t1;
26 ERROR 42S02: Table 'federated.t1' doesn't exist
27 DROP TABLE IF EXISTS federated.t1;
28 SET @@GLOBAL.DEBUG='+d,bug33962357_simulate_null_server';
29 CREATE TABLE federated.t1 (
30 a int
31 ) ENGINE="FEDERATED"
32 CONNECTION='fedlink/t1';
33 ERROR HY000: server name: 'fedlink' doesn't exist!
34 SELECT * FROM federated.t1;
35 ERROR 42S02: Table 'federated.t1' doesn't exist
36 SET GLOBAL DEBUG= @debug_save;
37 DROP SERVER fedlink;
38 DROP TABLE IF EXISTS federated.t1;
39 DROP DATABASE federated;
40 DROP TABLE IF EXISTS federated.t1;
41 DROP DATABASE federated;