Debian Codegraph @

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

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