summaryrefslogtreecommitdiff
path: root/sql/sql_select.cc
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2013-02-28 14:35:46 -0800
committerIgor Babaev <igor@askmonty.org>2013-02-28 14:35:46 -0800
commit90c0f3d3ab22272d59b88ffd75734ebcb087dd2a (patch)
treed7a55013f31799bfd4f1aac5da824f0db297fefa /sql/sql_select.cc
parent0d55ebc05ea303a9aea44d953abbc335c12c9330 (diff)
downloadmariadb-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.cc2
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;
}