• unknown's avatar
    bug#22027: CREATE TABLE IF NOT EXISTS SELECT logged improperly with rbr binlog, · 61c9a7d5
    unknown authored
    and #22762: create talbe if not exists like a-temp-table binlogged w/o "if not exists"
        These are rbr bugs.
        store_create_info, which generates the create statement e.g for binlogging,
        did not account a lex option HA_LEX_CREATE_IF_NOT_EXISTS.
        
        The fix makes the generated query to include the parent's statement option
    if
      that was supplied.
    
    
    mysql-test/extra/binlog_tests/binlog.test:
      test cases for #22027, #22762
    mysql-test/r/binlog_row_binlog.result:
      results changed
    mysql-test/r/binlog_row_mix_innodb_myisam.result:
      results changed because of the test's query has "if not exists"
    mysql-test/r/binlog_stm_binlog.result:
      results changed
    sql/sql_show.cc:
      store_create_info inserts "if not exists" into output when an input query contains
      the qualifier.
    61c9a7d5
binlog.test 1.85 KB