EVOLUTION-MANAGER

Edit File: federated_bug_32426.result

connect master,127.0.0.1,root,,test,$MASTER_MYPORT,; connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,; connection master; CREATE DATABASE federated; connection slave; CREATE DATABASE federated; # # Bug #32426: FEDERATED query returns corrupt results for ORDER BY # on a TEXT column # connection slave; CREATE TABLE federated.t1(a TEXT); INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de'); connection master; CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; SELECT * FROM federated.t1 ORDER BY A; a abc de f gh ijk SELECT * FROM federated.t1 ORDER BY A DESC; a ijk gh f de abc DROP TABLE federated.t1; connection slave; DROP TABLE federated.t1; connection default; connection master; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; connection slave; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated;