• unknown's avatar
    Fixed bug#19789: REPLACE was allowed for a VIEW with CHECK OPTION enabled. · 683ebcd1
    unknown authored
    The st_lex::which_check_option_applicable() function controls for which 
    statements WITH CHECK OPTION clause should be taken into account. REPLACE and
    REPLACE_SELECT wasn't in the list which results in allowing REPLACE to insert
    wrong rows in a such view.
    
    The st_lex::which_check_option_applicable() now includes REPLACE and 
    REPLACE_SELECT in the list of statements for which WITH CHECK OPTION clause is
    applicable.
    
    
    mysql-test/t/replace.test:
      Added test case for bug#19789: REPLACE was allowed for a VIEW with CHECK OPTION enabled.
    mysql-test/r/replace.result:
      Added test case for bug#19789: REPLACE was allowed for a VIEW with CHECK OPTION enabled.
    sql/sql_lex.h:
      Fixed bug#19789: REPLACE was allowed for a VIEW with CHECK OPTION enabled.
      The st_lex::which_check_option_applicable() now includes REPLACE and 
      REPLACE_SELECT in the list of statements for which WITH CHECK OPTION clause is
      applicable.
    683ebcd1
replace.test 1.19 KB