lp:~capttofu/maria/bug_571200

Branch merges

Propose for merging

No branches dependent on this one.

Ready for review for merging into lp:maria/5.3

Maria-captains: Pending requested 2010-08-03

Diff: 784 lines (+308/-104)

7 files modified

mysql-test/suite/federated/federated_bug_32426.result (+30/-0)
mysql-test/suite/federated/federated_bug_32426.test (+24/-0)
storage/federated/ha_federated.cc (+1/-1)
storage/federatedx/federatedx_io_mysql.cc (+60/-8)
storage/federatedx/federatedx_io_null.cc (+22/-0)
storage/federatedx/ha_federatedx.cc (+140/-75)
storage/federatedx/ha_federatedx.h (+31/-20)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #571200: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT

Medium

Fix Released

Link a bug report

Related blueprints

2804. By Patrick Galbraith <patg@patg-desktop> on 2010-07-23

Maria BUG# 571200, MySQL BUG# 32426: Fixed BLOG column order by for FederatedX

Applied Antony's fixes to what I had started. These fixes were from his
multi-bug fix at
http://bazaar.launchpad.net/~atcurtis/maria/federatedx/revision/2833
and are only the fixes for the ORDER BY BUG. I will also add separately the
other fixes per-bug

* Merged in fix for MySQL Bug#32426, http://lists.mysql.com/commits/102419
  However the io back-end is seperated from the front-end.
* Added 3 new methods for the i/o class to abstract result set cursor
  positioning. Note to future self pertaining to IO subclasses for other
  drivers such as ODBC
* Added test 'federated_bug_32426' to suite.

https://bugs.launchpad.net/maria/+bug/571200

2803. By Patrick Galbraith <patg@patg-desktop> on 2010-07-21

Work in progress with federated_io methods

2802. By Patrick Galbraith <patg@patg-desktop> on 2010-07-20

Work in progress on adding federatedx_io methods

Methods for result set and result set positions

2801. By Patrick Galbraith <patg@patg-desktop> on 2010-07-19

Work in progress fixing bug 571200.

Most of patch from http://lists.mysql.com/commits/102419 has been
integrated into FederatedX. Need to figure out how to set/get the
results->data_cursor to work with FEDERATEDX_IO_RESULT struct.

2800. By Oleksandr "Sanja" Byelkin on 2010-07-10

Subquery cache (MWL#66) added.

2799. By Sergey Petrunia on 2010-07-06

Fix buildbot valgrind failure
- Item_in_subselect::init_left_expr_cache() should not try to
  guess whether the left expression is accessed "over the grouping operation"
  (i.e. the subselect is evaluated after the grouping while the left_expr is
   an Item_ref that wraps an expression from before the grouping). Instead,
  let new_Cached_item not to try accessing item->real_item() when creating
  left expr cache.

2798. By Igor Babaev on 2010-07-02

Added missing calls of update_virtual_fields() in the
join cache module.
Without these calls SELECTs over tables with virtual columns
that used join cache could return wrong results. This could
be seen with the test case added into vcol_misc.test

2797. By Sergey Petrunia on 2010-06-27

Add sql/opt_index_cond_pushdown.cc to CMakeLists.txt files

2796. By Sergey Petrunia on 2010-06-26

Fix windows build: add sql/opt_subselect.cc to CMakeLists.txt files

2795. By Sergey Petrunia on 2010-06-26

Fix valgrind failure: when creating key image, don't try to copy out more than
  field->pack_length() bytes.