mirror of
https://github.com/MariaDB/server.git
synced 2026-02-23 02:58:40 +01:00
cc219b3dfc
Queries having the form select * from t1 where (a+1, b) IN ((1,1),(2,2),(3,3)); where a+1 is a virtual column will now be optimized to use that virtual column such that the above becomes select * from t1 where (vcol, b) IN ((1,1),(2,2),(3,3)); In general, vcol substitution will occur when a row itself contains the matching vcol expression. The optimizer will not only inspect the left-hand argument to IN for the matching expression, but will also unpack and inspect the left-hand argument when it is a row. |
||
|---|---|---|
| .. | ||
| alter_inplace-9045.result | ||
| binlog.result | ||
| charsets.result | ||
| cross_db.result | ||
| delayed.result | ||
| func_regexp.result | ||
| index.result | ||
| innodb_autoinc_vcol.result | ||
| innodb_virtual_fk.result | ||
| load_data.result | ||
| mrr.result | ||
| myisam_repair_prefix_varchar.result | ||
| not_supported.result | ||
| partition.result | ||
| races.result | ||
| range.result | ||
| rpl_vcol.result | ||
| update.result | ||
| update_binlog.result | ||
| upgrade.result | ||
| vcol_archive.result | ||
| vcol_blackhole.result | ||
| vcol_blocked_sql_funcs.result | ||
| vcol_column_def_options_innodb.result | ||
| vcol_column_def_options_myisam.result | ||
| vcol_csv.result | ||
| vcol_handler_aria.result | ||
| vcol_handler_innodb.result | ||
| vcol_handler_myisam.result | ||
| vcol_ins_upd_innodb.result | ||
| vcol_ins_upd_myisam.result | ||
| vcol_keys_aria.result | ||
| vcol_keys_innodb.result | ||
| vcol_keys_myisam.result | ||
| vcol_memory.result | ||
| vcol_merge.result | ||
| vcol_misc.result | ||
| vcol_non_stored_columns_innodb.result | ||
| vcol_non_stored_columns_myisam.result | ||
| vcol_partition_innodb.result | ||
| vcol_partition_myisam.result | ||
| vcol_sargable.result | ||
| vcol_sargable_debug.result | ||
| vcol_select_innodb.result | ||
| vcol_select_myisam.result | ||
| vcol_sql_mode.result | ||
| vcol_sql_mode_datetime.result | ||
| vcol_sql_mode_time.result | ||
| vcol_sql_mode_timestamp.result | ||
| vcol_sql_mode_upgrade.result | ||
| vcol_supported_sql_funcs.result | ||
| vcol_syntax.result | ||
| vcol_trigger_sp_innodb.result | ||
| vcol_trigger_sp_myisam.result | ||
| vcol_utf32.result | ||
| vcol_view_innodb.result | ||
| vcol_view_myisam.result | ||
| wrong_arena.result | ||