maria:bb-10.6-mdev-31524-post-merge-fix

Branch merges

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related charm recipes

3a81e30... by Yuchen Pei <email address hidden> on 2023-08-04

MDEV-31524 Post-merge fixup

5ea5291... by Oleksandr "Sanja" Byelkin on 2023-08-02

Merge branch '10.5' into 10.6

61acb43... by Sergei Golubchik on 2023-08-01

MDEV-31822 ALTER TABLE ENGINE=x started failing instead of producing warning on unsupported TRANSACTIONAL=1

make TRANSACTIONAL table option behave similar to other engine-defined
table options. If the engine doesn't suport it:
* if specified expicitly in CREATE or ALTER - it's ER_UNKNOWN_OPTION
* an error or a warning depending on sql_mode IGNORE_BAD_TABLE_OPTIONS
* in ALTER TABLE from the engine that suppors it to the engine that
  doesn't - silently preserved (no warning)
* it is commented out in SHOW CREATE unless IGNORE_BAD_TABLE_OPTIONS

da09ae0... by Sergei Golubchik on 2023-07-13

MDEV-18114 Foreign Key Constraint actions don't affect Virtual Column

* invoke check_expression() for all vcol_info's in
  mysql_prepare_create_table() to check for FK CASCADE
* also check for SET NULL and SET DEFAULT
* to check against existing FKs when a vcol is added in ALTER TABLE,
  old FKs must be added to the new_key_list just like other indexes are
* check columns recursively, if vcol1 references vcol2,
  flags of vcol2 must be taken into account
* remove check_table_name_processor(), put that logic under
  check_vcol_func_processor() to avoid walking the tree twice

ab1191c... by Sergei Golubchik on 2023-07-13

cleanup: key->key_create_info.check_for_duplicate_indexes -> key->old

mark old keys in the ALTER TABLE with the `old` flag, not with
the `key_create_info.check_for_duplicate_indexes`.

This allows to mark old foreign keys too.

0c9794d... by Sergei Golubchik on 2023-06-29

cleanup: Item_field::check_vcol_func_processor()

to declutter Item_field::check_vcol_func_processor(), move alter_info
specific part of it into Alter_info::check_vcol_field()

b8233b3... by Sergei Golubchik on 2023-06-29

cleanup: put db/table_name into Alter_info

also, prefer Lex_table_name and Lex_ident over LEX_CSTRING

2f6d464... by Sergei Golubchik on 2023-07-11

cleanup: reorder enum_fk_option

f7a9f44... by Sergei Golubchik on 2023-07-10

cleanup: remove unused keyinfo flag

HA_UNIQUE_CHECK was
* only used internally by MyISAM/Aria
* only used for internal temporary tables (for DISTINCT)
* never saved in frm
* saved in MYI/MAD but only for temporary tables
* only set, never checked

it's safe to remove it and free the bit (there are only 16 of them)

383baa8... by Sergei Golubchik on 2023-07-13

cleanup: invert return code