148 tbl->keys_in_use_for_query= tbl->keys_in_use_for_group_by=
149 tbl->keys_in_use_for_order_by= tbl->getShare()->keys_in_use;
154 key_map index_join[INDEX_HINT_FORCE + 1];
155 key_map index_order[INDEX_HINT_FORCE + 1];
156 key_map index_group[INDEX_HINT_FORCE + 1];
157 bool have_empty_use_join=
false, have_empty_use_order=
false,
158 have_empty_use_group=
false;
159 List_iterator <Index_hint> iter(
index_hints->begin());
162 for (
int type= INDEX_HINT_IGNORE;
type <= INDEX_HINT_FORCE;
type++)
164 index_join[
type].reset();
165 index_order[
type].reset();
166 index_group[
type].reset();
173 if (hint->type == INDEX_HINT_USE && !hint->key_name)
175 if (hint->clause & INDEX_HINT_MASK_JOIN)
177 index_join[hint->type].reset();
178 have_empty_use_join=
true;
180 if (hint->clause & INDEX_HINT_MASK_ORDER)
182 index_order[hint->type].reset();
183 have_empty_use_order=
true;
185 if (hint->clause & INDEX_HINT_MASK_GROUP)
187 index_group[hint->type].reset();
188 have_empty_use_group=
true;
197 uint32_t pos= tbl->getShare()->doesKeyNameExist(hint->key_name);
198 if (pos == UINT32_MAX)
200 my_error(ER_KEY_DOES_NOT_EXITS, MYF(0), hint->key_name, alias);
204 if (hint->clause & INDEX_HINT_MASK_JOIN)
205 index_join[hint->type].set(pos);
206 if (hint->clause & INDEX_HINT_MASK_ORDER)
207 index_order[hint->type].set(pos);
208 if (hint->clause & INDEX_HINT_MASK_GROUP)
209 index_group[hint->type].set(pos);
213 if ((index_join[INDEX_HINT_FORCE].any() ||
214 index_order[INDEX_HINT_FORCE].any() ||
215 index_group[INDEX_HINT_FORCE].any()) &&
216 (index_join[INDEX_HINT_USE].any() || have_empty_use_join ||
217 index_order[INDEX_HINT_USE].any() || have_empty_use_order ||
218 index_group[INDEX_HINT_USE].any() || have_empty_use_group))
220 my_error(ER_WRONG_USAGE, MYF(0), index_hint_type_name[INDEX_HINT_USE], index_hint_type_name[INDEX_HINT_FORCE]);
225 if (index_join[INDEX_HINT_FORCE].any() ||
226 index_order[INDEX_HINT_FORCE].any() ||
227 index_group[INDEX_HINT_FORCE].any())
229 tbl->force_index=
true;
230 index_join[INDEX_HINT_USE]|= index_join[INDEX_HINT_FORCE];
231 index_order[INDEX_HINT_USE]|= index_order[INDEX_HINT_FORCE];
232 index_group[INDEX_HINT_USE]|= index_group[INDEX_HINT_FORCE];
236 if (index_join[INDEX_HINT_USE].any() || have_empty_use_join)
237 tbl->keys_in_use_for_query&= index_join[INDEX_HINT_USE];
238 if (index_order[INDEX_HINT_USE].any() || have_empty_use_order)
239 tbl->keys_in_use_for_order_by&= index_order[INDEX_HINT_USE];
240 if (index_group[INDEX_HINT_USE].any() || have_empty_use_group)
241 tbl->keys_in_use_for_group_by&= index_group[INDEX_HINT_USE];
244 key_map_subtract(tbl->keys_in_use_for_query, index_join[INDEX_HINT_IGNORE]);
245 key_map_subtract(tbl->keys_in_use_for_order_by, index_order[INDEX_HINT_IGNORE]);
246 key_map_subtract(tbl->keys_in_use_for_group_by, index_group[INDEX_HINT_IGNORE]);
250 tbl->covering_keys&= tbl->keys_in_use_for_query;