diff options
| author | Sergey Vojtovich <svoj@mariadb.org> | 2013-09-06 15:59:19 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2013-09-06 15:59:19 +0400 |
| commit | bbc9e57981d8aa420d7bcf58e3fb2d7c1bf25ca9 (patch) | |
| tree | 4840f695abcffc893f8b7d8d9d62d3e1cdf85a1e /sql/sql_cursor.cc | |
| parent | 078388f39ca8d6f0b5188cc060a7f0e1c2808d87 (diff) | |
| download | mariadb-git-bbc9e57981d8aa420d7bcf58e3fb2d7c1bf25ca9.tar.gz | |
MDEV-4978 - Server cursor is broken with blobs in the select list,
ORDER BY does not work
Use "dynamic" row format (instead of "block") for MARIA internal
temporary tables created for cursors.
With "block" row format MARIA may shuffle rows, with "dynamic" row
format records are inserted sequentially (there are no gaps in data
file while we fill temporary tables).
This is needed to preserve row order when scanning materialized cursors.
Diffstat (limited to 'sql/sql_cursor.cc')
| -rw-r--r-- | sql/sql_cursor.cc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sql_cursor.cc b/sql/sql_cursor.cc index 3758bf27819..230a8b2c802 100644 --- a/sql/sql_cursor.cc +++ b/sql/sql_cursor.cc @@ -389,7 +389,7 @@ bool Select_materialize::send_result_set_metadata(List<Item> &list, uint flags) if (create_result_table(unit->thd, unit->get_unit_column_types(), FALSE, thd->variables.option_bits | TMP_TABLE_ALL_COLUMNS, - "", FALSE, TRUE)) + "", FALSE, TRUE, TRUE)) return TRUE; materialized_cursor= new (&table->mem_root) |