• unknown's avatar
    Bug #34283 mysqlbinlog leaves tmpfile after termination if binlog contains load data infile · bcb3170c
    unknown authored
    With statement- or mixed-mode logging, "LOAD DATA INFILE" queries
    are written to the binlog using special types of log events.
    When mysqlbinlog reads such events, it re-creates the file in a
    temporary directory with a generated filename and outputs a
    "LOAD DATA INFILE" query where the filename is replaced by the
    generated file. The temporary file is not deleted by mysqlbinlog
    after termination.
    
    To fix the problem, in mixed mode we go to row-based. In SBR, we
    document it to remind user the tmpfile is left in a temporary
    directory.
    
    
    
    
    mysql-test/extra/rpl_tests/rpl_loaddata.test:
      Updated for Bug#34283
    mysql-test/suite/binlog/r/binlog_mixed_load_data.result:
      Test result for BUG#34283.
    mysql-test/suite/binlog/t/binlog_killed_simulate.test:
      Updated for Bug#34283
    mysql-test/suite/binlog/t/binlog_mixed_load_data.test:
      Added the test file to verify that 'load data infile...' statement
      will go to row-based in mixed mode.
    mysql-test/suite/binlog/t/binlog_stm_blackhole.test:
      Updated for Bug#34283
    mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result:
      Updated for Bug#34283
    mysql-test/suite/rpl/t/rpl_loaddata_fatal.test:
      Updated for Bug#34283
    mysql-test/suite/rpl/t/rpl_loaddata_map.test:
      Updated for Bug#34283
    mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test:
      Updated for Bug#34283
    mysql-test/suite/rpl/t/rpl_stm_log.test:
      Updated for Bug#34283
    sql/sql_load.cc:
      Added code to go to row-based in mixed mode for
      'load data infile ...' statement
    bcb3170c
binlog_stm_blackhole.test 267 Bytes