diff options
author | Igor Babaev <igor@askmonty.org> | 2013-02-28 14:35:46 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2013-02-28 14:35:46 -0800 |
commit | 90c0f3d3ab22272d59b88ffd75734ebcb087dd2a (patch) | |
tree | d7a55013f31799bfd4f1aac5da824f0db297fefa /sql/sql_select.cc | |
parent | 0d55ebc05ea303a9aea44d953abbc335c12c9330 (diff) | |
download | mariadb-git-90c0f3d3ab22272d59b88ffd75734ebcb087dd2a.tar.gz |
Fixed bug mdev-4209
Do not include BLOB fields into the key to access the temporary
table created for a materialized view/derived table.
BLOB components are not allowed in keys.
Diffstat (limited to 'sql/sql_select.cc')
-rw-r--r-- | sql/sql_select.cc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sql_select.cc b/sql/sql_select.cc index d308bef19c2..75f810598cd 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -3954,7 +3954,7 @@ add_key_field(JOIN *join, !(field->table->pos_in_table_list->is_materialized_derived() && field->table->created)) || (field->table->pos_in_table_list->is_materialized_derived() && - !field->table->created))) + !field->table->created && !(field->flags & BLOB_FLAG)))) { optimize= KEY_OPTIMIZE_EQ; } |