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/t/
View File Name : rpl_typeconv.test

#Want to skip this test from daily Valgrind execution
--source include/no_valgrind_without_big.inc
--source include/not_group_replication_plugin.inc
--source include/not_gtid_enabled.inc

--source include/have_binlog_format_row.inc
--source include/master-slave.inc

connection slave;
--let $saved_log_error_verbosity=`SELECT @@global.log_error_verbosity`
set @saved_slave_type_conversions = @@global.slave_type_conversions;
CREATE TABLE type_conversions (
       TestNo INT AUTO_INCREMENT PRIMARY KEY,
       Source TEXT,
       Target TEXT,
       Flags TEXT,
       On_Master TEXT,
       On_Slave TEXT,
       Expected TEXT,
       Compare INT,
       Error TEXT);

SELECT @@global.slave_type_conversions;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='';
SELECT @@global.slave_type_conversions;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY';
SELECT @@global.slave_type_conversions;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY';
SELECT @@global.slave_type_conversions;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY';
SELECT @@global.slave_type_conversions;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY,NONEXISTING_BIT';
SELECT @@global.slave_type_conversions;

# Disabling warnings to not flood the error log, otherwise it might
# cause sporadic test failures during the 'check warnings' stage because
# the log would be too large and the platform to slow to parse it in
# time. The errors are still logged to the error log, but hoepfully,
# the amount of warnings that we are removing from the log is good 
# enough to make the test less vulnerable.
SET @@global.log_error_verbosity=1;
--source include/stop_slave.inc
--source include/start_slave.inc

# Checking strict interpretation of type conversions
connection slave;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='';
source extra/rpl_tests/type_conversions.test;

# Checking lossy integer type conversions
connection slave;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY';
source extra/rpl_tests/type_conversions.test;

# Checking non-lossy integer type conversions
connection slave;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY';
source extra/rpl_tests/type_conversions.test;

# Checking all type conversions
connection slave;
SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY';
source extra/rpl_tests/type_conversions.test;

# reinstate the log_error_verbosity value
--replace_result $saved_log_error_verbosity SAVED_LOG_ERROR_VERBOSITY
--eval SET @@global.log_error_verbosity= $saved_log_error_verbosity

connection slave;
--echo **** Result of conversions ****
disable_query_log;
SELECT RPAD(Source, 15, ' ') AS Source_Type,
       RPAD(Target, 15, ' ') AS Target_Type,
       RPAD(Flags, 25, ' ') AS All_Type_Conversion_Flags,
       IF(Compare IS NULL AND Error IS NOT NULL, '<Correct error>',
          IF(Compare, '<Correct value>',
             CONCAT("'", On_Slave, "' != '", Expected, "'")))
         AS Value_On_Slave
  FROM type_conversions;
enable_query_log;
DROP TABLE type_conversions;

call mtr.add_suppression("Slave SQL.*Column 1 of table .test.t1. cannot be converted from type.* Error_code: 1677");
call mtr.add_suppression("The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state");

connection master;
DROP TABLE t1;
--source include/sync_slave_sql_with_master.inc

set global slave_type_conversions = @saved_slave_type_conversions;

--source include/rpl_end.inc