Debian Codegraph @

mysql-test/suite/federated/federated_bug_32426.test

raw
1 source include/federated.inc;
2
3 --echo #
4 --echo # Bug #32426: FEDERATED query returns corrupt results for ORDER BY
5 --echo # on a TEXT column
6 --echo #
7 connection slave;
8 CREATE TABLE federated.t1(a TEXT);
9 INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de');
10
11 connection master;
12 --replace_result $SLAVE_MYPORT SLAVE_PORT
13 eval CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED
14 CONNECTION='mysql://[email protected]:$SLAVE_MYPORT/federated/t1';
15 SELECT * FROM federated.t1 ORDER BY A;
16 SELECT * FROM federated.t1 ORDER BY A DESC;
17 DROP TABLE federated.t1;
18
19 connection slave;
20 DROP TABLE federated.t1;
21
22 connection default;
23
24 source include/federated_cleanup.inc;