• unknown's avatar
    Bug#32575 - Parse error of stmt with extended comments on slave side · a6f7fa35
    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'.
    a6f7fa35
sql_view.cc 55.9 KB