mirror of
https://github.com/MariaDB/server.git
synced 2026-02-03 01:09:07 +01:00
When a column or alias is the GROUP BY item, and a HAVING conjunct depends on this column/alias only, the HAVING conjunct could contain an Item_ref pointing to the GROUP BY Item_field. If the column/alias happens to the be the expression of a vcol, the GROUP BY item would be substituted with a newly created vcol Item_field (MDEV-36132). This causes the Item_ref in HAVING to point to the new vcol Item_field as well. Subsequently in the HAVING to WHERE pushdown optimization, the conjunct is moved to WHERE and fix_fields is called on it, where it expects the vcol Item_field to have a name resolution context. So we let the vcol Item_field inherit the context from the select_lex. |
||
|---|---|---|
| .. | ||
| alter_inplace-9045.test | ||
| binlog.test | ||
| charsets.test | ||
| cross_db.test | ||
| delayed.test | ||
| func_regexp.test | ||
| index.test | ||
| innodb_autoinc_vcol.test | ||
| innodb_virtual_fk.test | ||
| load_data.test | ||
| mrr.test | ||
| myisam_repair_prefix_varchar.test | ||
| not_supported.test | ||
| order_by_group_by_subst.test | ||
| order_by_group_by_subst_notembedded.test | ||
| partition.test | ||
| query_cache.test | ||
| races.test | ||
| range.test | ||
| rpl_vcol.test | ||
| update.test | ||
| update_binlog.test | ||
| upgrade.test | ||
| vcol_archive.test | ||
| vcol_blackhole.test | ||
| vcol_blocked_sql_funcs.test | ||
| vcol_blocked_sql_funcs_main.inc | ||
| vcol_column_def_options_innodb.test | ||
| vcol_column_def_options_myisam.test | ||
| vcol_csv.test | ||
| vcol_handler_aria.test | ||
| vcol_handler_innodb.test | ||
| vcol_handler_myisam.test | ||
| vcol_ins_upd_innodb.test | ||
| vcol_ins_upd_myisam.test | ||
| vcol_keys_aria.test | ||
| vcol_keys_innodb.opt | ||
| vcol_keys_innodb.test | ||
| vcol_keys_myisam.test | ||
| vcol_memory.test | ||
| vcol_merge.test | ||
| vcol_misc.opt | ||
| vcol_misc.test | ||
| vcol_non_stored_columns_innodb.test | ||
| vcol_non_stored_columns_myisam.test | ||
| vcol_partition_innodb.test | ||
| vcol_partition_myisam.test | ||
| vcol_sargable.test | ||
| vcol_sargable_debug.test | ||
| vcol_select_innodb.test | ||
| vcol_select_myisam.test | ||
| vcol_sql_mode.test | ||
| vcol_sql_mode_datetime.test | ||
| vcol_sql_mode_time.test | ||
| vcol_sql_mode_timestamp.test | ||
| vcol_sql_mode_upgrade.test | ||
| vcol_supported_sql_funcs.test | ||
| vcol_supported_sql_funcs_main.inc | ||
| vcol_syntax.test | ||
| vcol_trigger_sp_innodb.test | ||
| vcol_trigger_sp_myisam.test | ||
| vcol_utf32.test | ||
| vcol_view_innodb.test | ||
| vcol_view_myisam.test | ||
| wrong_arena.test | ||