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

-- source include/have_myisam.inc
-- source include/have_binlog_format_statement.inc
RESET MASTER;
#
# BUG#49562: SBR out of sync when using numeric data types + user variable
#

-- let $max_unsigned_long= 18446744073709551615
-- let $min_signed_long= -9223372036854775808
-- eval SET @positive= $max_unsigned_long
-- eval SET @negative= $min_signed_long

CREATE TABLE t1 (`tinyint` TINYINT,
                 `smallint` SMALLINT,
                 `mediumint` MEDIUMINT,
                 `integer` INTEGER,
                 `bigint` BIGINT,
                 `utinyint` TINYINT UNSIGNED,
                 `usmallint` SMALLINT UNSIGNED,
                 `umediumint` MEDIUMINT UNSIGNED,
                 `uinteger` INTEGER UNSIGNED,
                 `ubigint` BIGINT UNSIGNED,
                 `double` DOUBLE,
                 `float` FLOAT,
                 `real` REAL(30,2),
                 `decimal` DECIMAL(30,2)) ENGINE = MyISAM;

-- echo ### insert max unsigned
-- echo ### a) declarative
-- disable_warnings
-- eval INSERT IGNORE INTO t1 VALUES ($max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long,$max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long, $max_unsigned_long);
-- enable_warnings
TRUNCATE t1;

-- echo ### b) user var
-- disable_warnings
INSERT IGNORE INTO t1 VALUES (@positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive,
                              @positive);
-- enable_warnings

-- echo ## assertion: checks that User_var_log_event::pack_info 
-- echo ## correctly displays the binlog content by taking into 
-- echo ## account the unsigned_flag
-- source include/show_binlog_events.inc

-- echo ### insert min signed
-- echo ### a) declarative
-- disable_warnings
-- eval INSERT IGNORE INTO t1 VALUES ($min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long,$min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long, $min_signed_long);
-- enable_warnings
TRUNCATE t1;

-- echo ### b) user var
-- disable_warnings
INSERT IGNORE INTO t1 VALUES (@negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative,
                              @negative);
-- enable_warnings

-- echo ## assertion: checks that User_var_log_event::pack_info 
-- echo ## correctly displays the binlog content by taking into 
-- echo ## account the unsigned_flag
-- source include/show_binlog_events.inc

DROP TABLE t1;