• unknown's avatar
    Bug #34283 mysqlbinlog leaves tmpfile after termination if binlog contains load data infile · 3ac02654
    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/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.test:
      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 B
    mysys/stacktrace.c:
      Auto merge
    sql/sql_lex.cc:
      Auto merg
    sql/sql_load.cc:
      Added code to go to row-based in mixed mode for
      'load data infile ...' statement
    3ac02654
binlog_killed_simulate.test 2.6 KB