mirror of
https://github.com/MariaDB/server.git
synced 2026-02-23 19:18:59 +01:00
10643cffe9
Oracle mode has no priority between set-operators but the current implementation with disable_index_if_needed() can not work with arbitrary mix of distinct/non-distinct set-operators as the algorithm is tied to the properly wrapped version of expression. Index can be disabled only once and cannot be reenabled afterwards. To adapt Oracle mode for the aforementioned implementation we prioritize each set operator with parens in the order of appearance. So the expression: S1 op1 S2 op2 S3 op3 S4 will be rewritten like this: (((S1 op1 S2) op2 S3) op3 S4). The rewritten expression is valid for both Oracle and default mode and renders the same result. Prioritizing is done with create_priority_nest() but it was tweaked to work with derived to be the first operand. Originally create_priority_nest() could wrap only second operand, like this: S1 op1 S2 op2 S3 -> S1 op1 (S2 op2 S3). Now this behaviour is kept by non-NULL attach_to argument. With NULL attach_to argument it produces this transformation: S1 op1 S2 -> (S1 op1 S2), but to be strict it will look like this: SELECT .. FROM (S1 op1 S2). This expression is treated as the first one in the select list, so nothing to "attach to". On importance of not making fake_select_lex after create_priority_nest() in parsed_select_expr_start(). This will fail nastily in Protocol::valid_handler() check in store_longlong() for EXPLAIN. This happens because select_options are inherited from newly made fake_select_lex but without SELECT_DESCRIBE flag which is meant to be assigned by mysql_explain_union() but union_needs_tmp_table() is false (because now top-level unit has no set-operator, it is just select from derived), so SELECT_DESCRIBE assignment is skipped. Depending on that flag send_result_set_metadata() is conditionally executed in JOIN::exec_inner(). And originally it is done via select_describe() branch for top-level select when there is no set operator (it is select from derived as explained above), not via direct send_result_set_metadata(). On IS_OR_WAS_ORACLE. Sql_mode_save_for_frm_handling removes MODE_ORACLE when view is registered or opened. We cannot return it back as this conflicts with MDEV-12478 (tested by compat/oracle.func_concat). So we are temporarily adding WAS_ORACLE flag instead. WAS_MODE_ORACLE is for testing both WAS_ORACLE and MODE_ORACLE simultaneously. |
||
|---|---|---|
| .. | ||
| anonymous_derived.result | ||
| binlog_ptr_mysqlbinlog.result | ||
| binlog_stm_ps.result | ||
| binlog_stm_sp.result | ||
| binlog_stm_sp_package.result | ||
| column_compression.result | ||
| custom_aggregate_functions.result | ||
| empty_string_literal.result | ||
| events.result | ||
| exception.result | ||
| func_add_months.result | ||
| func_case.result | ||
| func_concat.result | ||
| func_decode.result | ||
| func_length.result | ||
| func_misc.result | ||
| func_pad.result | ||
| func_qualified.result | ||
| func_regexp_replace.result | ||
| func_replace.result | ||
| func_substr.result | ||
| func_time.result | ||
| func_to_char.result | ||
| func_trim.result | ||
| gis-debug.result | ||
| gis.result | ||
| information_schema_parameters.result | ||
| keywords.result | ||
| minus.result | ||
| misc.result | ||
| mysqldump_restore.result | ||
| mysqldump_restore_func_qualified.result | ||
| parser.result | ||
| plugin.result | ||
| ps.result | ||
| rpl_mariadb_date.result | ||
| rpl_sp_package.result | ||
| rpl_sp_package_variables.result | ||
| sequence.result | ||
| sp-anchor-row-type-table.result | ||
| sp-anonymous.result | ||
| sp-code.result | ||
| sp-cursor-decl.result | ||
| sp-cursor-rowtype.result | ||
| sp-cursor.result | ||
| sp-expr.result | ||
| sp-goto-debug.result | ||
| sp-goto.result | ||
| sp-inout.result | ||
| sp-memory-leak.result | ||
| sp-package-code.result | ||
| sp-package-concurrent-dml-db.result | ||
| sp-package-concurrent-dml-package.result | ||
| sp-package-concurrent-dml-trigger.result | ||
| sp-package-concurrent-dml-view.result | ||
| sp-package-i_s.result | ||
| sp-package-innodb.result | ||
| sp-package-mdl.result | ||
| sp-package-mysqldump.result | ||
| sp-package-security.result | ||
| sp-package.result | ||
| sp-param.result | ||
| sp-row.result | ||
| sp-security.result | ||
| sp.result | ||
| statement-expr.result | ||
| table_value_constr.result | ||
| trigger.result | ||
| truncate.result | ||
| type_blob.result | ||
| type_clob.result | ||
| type_date.result | ||
| type_number.result | ||
| type_raw.result | ||
| type_varchar.result | ||
| type_varchar2.result | ||
| update.result | ||
| update_innodb.result | ||
| variables.result | ||
| vcol.result | ||
| vcol_innodb.result | ||
| versioning.result | ||
| win.result | ||