Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/rpl/include/

Edit File: rpl_only_stmt_unsafe.inc

# Check that the last statement executed harvested
#
# binlog_format | query_get_value(SHOW WARNINGS LIMIT 1, Message, 1)
# --------------+---------------------------------------------------
#     statement | Unsafe statement written to the binary log.....
#  <> statement | No such row     (no warning at all)
#

let $my_value= query_get_value(SHOW WARNINGS LIMIT 1, Message, 1);
if (`SELECT (NOT ('$my_value' LIKE 'Unsafe statement written to the binary log%'
                  AND @@binlog_format = 'statement'))
            AND
            (NOT ('$my_value' LIKE 'No such row'
                  AND @@binlog_format <> 'statement')) `)
{
   --echo ERROR:
   --echo Last statement is
   --echo - unsafe in case of binlog_format  = 'statement'
   --echo   Expect to get a warning.
   --echo -   safe in case of binlog_format <> 'statement'
   --echo   Expect to get 'No such row'.
   --echo Result of SHOW WARNINGS via query_get_value : '$my_value'
   SELECT @@binlog_format;
   --echo Abort
   exit;
}
let $my_value= 'Garbage';