• unknown's avatar
    Bug#32575 - Parse error of stmt with extended comments on slave side · 61c3310f
    unknown authored
    Problem was that mysql_create_view did not remove all comments characters
    when writing to binlog, resulting in parse error of stmt on slave side.
    
    Solution was to use the recreated select clause
    and add a generated CHECK OPTION clause if needed.
    
    
    mysql-test/r/rpl_sp.result:
      Bug#32575 - Parse error of stmt with extended comments on slave side
      
      Updated test result
    mysql-test/r/rpl_view.result:
      Bug#32575 - Parse error of stmt with extended comments on slave side
      
      Updated test result
    mysql-test/t/rpl_view.test:
      Bug#32575 - Parse error of stmt with extended comments on slave side
      
      Added test case
    sql/sql_view.cc:
      Bug#32575 - Parse error of stmt with extended comments on slave side
      
      Problem was that mysql_create_view did not remove all comments characters
      when writing to binlog, resulting in parse error of stmt on slave side.
      
      Solution was to use the recreated select clause and generate
      'WITH {LOCAL|CASCADED} CHECK OPTION'.
    61c3310f
rpl_view.test 3.63 KB