• Sergei Golubchik's avatar
    MDEV-18114 Foreign Key Constraint actions don't affect Virtual Column · da09ae05
    Sergei Golubchik authored
    * 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
    da09ae05
innodb_virtual_basic.test 41.5 KB