Debian Codegraph @

mysql-test/suite/federated/t/percona_bug1739734.test

raw
1 --echo #
2 --echo # Bug lp1739734 "Federated table returns error 1430 from storage engine"
3 --echo #
4 --echo # This is a bug introduced in the artful/gcc7 compilation fixes, caused by
5 --echo # a moved break statement.
6
7 --source suite/federated/include/federated.inc
8
9 connection master;
10 CREATE DATABASE lp1739734;
11 use lp1739734;
12
13 --replace_result $MASTER_MYPORT MASTER_PORT
14 eval CREATE SERVER local_server
15 FOREIGN DATA WRAPPER mysql
16 OPTIONS (
17 HOST '127.0.0.1',
18 PORT $MASTER_MYPORT,
19 USER 'root',
20 PASSWORD '',
21 DATABASE 'lp1739734'
22 );
23
24 CREATE TABLE remote_table (
25 a INT,
26 b INT,
27 KEY ab (a,b),
28 KEY ba (b,a)
29 );
30
31
32 CREATE TABLE local_table (
33 a INT,
34 b INT,
35 KEY ab (a,b),
36 KEY ba (b,a)
37 ) ENGINE=federated CONNECTION='local_server/remote_table';
38
39 SELECT * FROM local_table;
40
41 SELECT * FROM local_table USE INDEX (ab)
42 WHERE a<1 AND b=0;
43
44 SELECT * FROM local_table USE INDEX (ba)
45 WHERE a<1 AND b=0;
46
47 DROP DATABASE lp1739734;
48 DROP SERVER local_server;
49
50 --source suite/federated/include/federated_cleanup.inc