Debian Codegraph @

mysql-test/suite/federated/federated_bug_32426.result

raw
1 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
2 connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,;
3 connection master;
4 CREATE DATABASE federated;
5 connection slave;
6 CREATE DATABASE federated;
7 #
8 # Bug #32426: FEDERATED query returns corrupt results for ORDER BY
9 # on a TEXT column
10 #
11 connection slave;
12 CREATE TABLE federated.t1(a TEXT);
13 INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de');
14 connection master;
15 CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED
16 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
17 SELECT * FROM federated.t1 ORDER BY A;
18 a
19 abc
20 de
21 f
22 gh
23 ijk
24 SELECT * FROM federated.t1 ORDER BY A DESC;
25 a
26 ijk
27 gh
28 f
29 de
30 abc
31 DROP TABLE federated.t1;
32 connection slave;
33 DROP TABLE federated.t1;
34 connection default;
35 connection master;
36 DROP TABLE IF EXISTS federated.t1;
37 DROP DATABASE IF EXISTS federated;
38 connection slave;
39 DROP TABLE IF EXISTS federated.t1;
40 DROP DATABASE IF EXISTS federated;