• Sergey Glukhov's avatar
    Bug#37460 Assertion failed: !table->file || table->file->inited == handler::NONE · 89d04406
    Sergey Glukhov authored
    enable uncacheable flag if we update a view with check option
    and check option has a subselect, otherwise, the check option
    can be evaluated after the subselect was freed as independent
    (See full_local in JOIN::join_free())
    
    
    mysql-test/r/subselect.result:
      test result
    mysql-test/t/subselect.test:
      test case
    sql/mysql_priv.h:
      added UNCACHEABLE_CHECKOPTION flag
    sql/sql_update.cc:
      enable uncacheable flag if we update a view with check option
      and check option has a subselect, otherwise, the check option
      can be evaluated after the subselect was freed as independent
      (See full_local in JOIN::join_free())
    89d04406
subselect.test 122 KB