diff options
| author | Michael Widenius <monty@mysql.com> | 2010-08-18 10:52:57 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@mysql.com> | 2010-08-18 10:52:57 +0300 |
| commit | 909e4eb08d7ea38cf09575756cff79648e326fd5 (patch) | |
| tree | 84729e5a7b409cbe8b58a888fb76762ed3900f0d /mysql-test/suite/federated/federated_bug_32426.test | |
| parent | 6795a545e382a2de7104cdc57e0a2834e4aa9b67 (diff) | |
| download | mariadb-git-909e4eb08d7ea38cf09575756cff79648e326fd5.tar.gz | |
Added verbose mode to recovery
More DBUG
Added convert-debug-for-diff
Added missing (from last push) federated test case
.bzrignore:
Ignore generated files
mysql-test/README:
Updated documentation for --extern
mysql-test/suite/federated/federated_bug_32426.result:
Added test for federatedx
mysql-test/suite/federated/federated_bug_32426.test:
Added test for federatedx
scripts/Makefile.am:
Added convert-debug-for-diff
scripts/convert-debug-for-diff.sh:
Added script for converting
sql/log.cc:
Added DBUG
sql/mysqld.cc:
Added DBUG
storage/maria/ma_recovery.c:
If verbose, write dirty pages (for debugging)
storage/maria/ma_static.c:
Added verbose mode to recovery
storage/maria/maria_def.h:
Added verbose mode to recovery
storage/maria/maria_read_log.c:
Added verbose mode to recovery
Diffstat (limited to 'mysql-test/suite/federated/federated_bug_32426.test')
| -rw-r--r-- | mysql-test/suite/federated/federated_bug_32426.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated_bug_32426.test b/mysql-test/suite/federated/federated_bug_32426.test new file mode 100644 index 00000000000..254dfaa610a --- /dev/null +++ b/mysql-test/suite/federated/federated_bug_32426.test @@ -0,0 +1,24 @@ +source federated.inc; + +--echo # +--echo # Bug #32426: FEDERATED query returns corrupt results for ORDER BY +--echo # on a TEXT column +--echo # +connection slave; +CREATE TABLE federated.t1(a TEXT); +INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de'); + +connection master; +--replace_result $SLAVE_MYPORT SLAVE_PORT +eval CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED + CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1'; +SELECT * FROM federated.t1 ORDER BY A; +SELECT * FROM federated.t1 ORDER BY A DESC; +DROP TABLE federated.t1; + +connection slave; +DROP TABLE federated.t1; + +connection default; + +source federated_cleanup.inc; |