• unknown's avatar
    Fixed bug #27827. · f284baee
    unknown authored
    ON conditions from JOIN expression were ignored at CHECK OPTION
    check when updating a multi-table view with CHECK OPTION.
    
    The st_table_list::prep_check_option function has been
    modified to to take into account ON conditions at CHECK OPTION check
    It was also changed to build the check option condition only once
    for any update used in PS/SP.
    
    
    sql/table.h:
      Fixed bug #27827.
      The st_table_list::check_option_processed variable has been added
      to build the check option condition only once for any update used
      in PS/SP.
    sql/table.cc:
      Fixed bug #27827.
      The st_table_list::prep_check_option function has been
      modified to to take into account ON conditions at CHECK OPTION check
      It was also changed to build the check option condition only once
      for any update used in PS/SP.
    mysql-test/t/view.test:
      Updated test case for bug #27827.
    mysql-test/r/view.result:
      Updated test case for bug #27827.
    f284baee
view.test 82.3 KB