• unknown's avatar
    Bug #57666 Unclear warning with broken text in error log on INSERT DELAYED · 8a7d266d
    unknown authored
    It is not necessary to support INSERT DELAYED for a single value insert,
    while we do not support that for multi-values insert when binlog is
    enabled in SBR.
    
    The lock_type is upgrade to TL_WRITE from TL_WRITE_DELAYED for
    INSERT DELAYED for single value insert as multi-values insert
    did when binlog is enabled. Then it's safe. And binlog it as
    INSERT without DELAYED.
    
    mysql-test/extra/binlog_tests/binlog_insert_delayed.test:
      Added test case for bug#57666.
    mysql-test/suite/binlog/r/binlog_row_binlog.result:
      Updated for bug#57666
    mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result:
      Updated for bug#57666
    mysql-test/suite/binlog/r/binlog_stm_binlog.result:
      Updated for bug#57666
    mysql-test/suite/rpl/r/rpl_stm_insert_delayed.result:
      Updated for bug#57666
    sql/sql_insert.cc:
      Updated code for the following things:
      1. Upgrade the lock_type to TL_WRITE from TL_WRITE_DELAYED
      for INSERT DELAYED for single value insert as multi-values
      insert did when binlog is enabled.
      2. Clear code to not binlog INSERT DELAYED STMT in SBR.
      3. Get rid of privilege check for log_on.
    8a7d266d
binlog_row_binlog.result 76.6 KB