Gecko [ www.jdcpatala.org ]

Name	Size	Permission
check_type.inc	2.29 KB	-rw-r--r--
create_recursive_construct.inc	16.61 KB	-rw-r--r--
create_recursive_construct_stm...	16.48 KB	-rw-r--r--
delayed_slave_wait_on_query.in...	1.59 KB	-rw-r--r--
gtid_disconnect_drop_temporary...	3.11 KB	-rw-r--r--
rpl_EE_err.test	1.03 KB	-rw-r--r--
rpl_auto_increment.test	8.63 KB	-rw-r--r--
rpl_auto_increment_insert_view...	1.37 KB	-rw-r--r--
rpl_auto_increment_invoke_trig...	2.47 KB	-rw-r--r--
rpl_autoinc_func_invokes_trigg...	1.78 KB	-rw-r--r--
rpl_binlog_max_cache_size.test	18.23 KB	-rw-r--r--
rpl_blackhole.test	1.03 KB	-rw-r--r--
rpl_change_master.test	10.46 KB	-rw-r--r--
rpl_change_master_bind.inc	2.23 KB	-rw-r--r--
rpl_charset.test	4.45 KB	-rw-r--r--
rpl_check_gtid.inc	4.87 KB	-rw-r--r--
rpl_commit_after_flush.test	272 B	-rw-r--r--
rpl_conflicts.test	5.45 KB	-rw-r--r--
rpl_crash_safe.inc	4.13 KB	-rw-r--r--
rpl_crash_safe.test	7.61 KB	-rw-r--r--
rpl_create_msr_channels.inc	2.53 KB	-rw-r--r--
rpl_db_stmts_ignored.inc	1.7 KB	-rw-r--r--
rpl_ddl.test	21.62 KB	-rw-r--r--
rpl_deadlock.test	6.05 KB	-rw-r--r--
rpl_delete_no_where.test	523 B	-rw-r--r--
rpl_do_table_filter_insensitiv...	492 B	-rw-r--r--
rpl_do_table_filter_sensitive....	491 B	-rw-r--r--
rpl_drop_create_temp_table.inc	29.79 KB	-rw-r--r--
rpl_drop_create_temp_table.tes...	17.8 KB	-rw-r--r--
rpl_drop_multiple_tables.inc	4 KB	-rw-r--r--
rpl_drop_multiple_tables_in_mu...	1.18 KB	-rw-r--r--
rpl_extra_col_master.test	31.93 KB	-rw-r--r--
rpl_extra_col_slave.test	28.76 KB	-rw-r--r--
rpl_failed_optimize.test	666 B	-rw-r--r--
rpl_filters.test	530 B	-rw-r--r--
rpl_flsh_tbls.test	1.86 KB	-rw-r--r--
rpl_foreign_key.test	1.7 KB	-rw-r--r--
rpl_generate_mts_gap.test	1.6 KB	-rw-r--r--
rpl_generate_mts_gap_with_miss...	3.22 KB	-rw-r--r--
rpl_generate_mts_gap_with_miss...	408 B	-rw-r--r--
rpl_get_master_version_and_clo...	2.88 KB	-rw-r--r--
rpl_gtid_drop_table.inc	1.11 KB	-rw-r--r--
rpl_gtid_mixed_rows_and_stmts_...	3.35 KB	-rw-r--r--
rpl_gtid_mts_relay_log_recover...	4.39 KB	-rw-r--r--
rpl_gtid_temp_table_in_func_or...	3.69 KB	-rw-r--r--
rpl_gtids_restart_slave_io_los...	3.48 KB	-rw-r--r--
rpl_heartbeat_2slaves.inc	4.27 KB	-rw-r--r--
rpl_ignore_super_read_only.tes...	6.19 KB	-rw-r--r--
rpl_ignore_table_filter_insens...	508 B	-rw-r--r--
rpl_ignore_table_filter_sensit...	506 B	-rw-r--r--
rpl_implicit_commit_binlog.tes...	17.22 KB	-rw-r--r--
rpl_innodb.test	4.53 KB	-rw-r--r--
rpl_insert_id.test	15.12 KB	-rw-r--r--
rpl_insert_id_pk.test	2.65 KB	-rw-r--r--
rpl_insert_ignore.test	4.9 KB	-rw-r--r--
rpl_kill_query.inc	4.14 KB	-rw-r--r--
rpl_loaddata.test	8.91 KB	-rw-r--r--
rpl_loaddata_s.inc	896 B	-rw-r--r--
rpl_loadfile.test	1.08 KB	-rw-r--r--
rpl_log.test	3.9 KB	-rw-r--r--
rpl_lower_case_table_names.tes...	4.07 KB	-rw-r--r--
rpl_max_relay_size.test	2.58 KB	-rw-r--r--
rpl_mixing_engines.inc	23.15 KB	-rw-r--r--
rpl_mixing_engines.test	54.43 KB	-rw-r--r--
rpl_mts_crash_safe.inc	5.92 KB	-rw-r--r--
rpl_mts_crash_safe.test	6.74 KB	-rw-r--r--
rpl_mts_execute_partial_trx_in...	1.11 KB	-rw-r--r--
rpl_mts_pending_events.inc	4.91 KB	-rw-r--r--
rpl_mts_relay_log_recovery.tes...	2.93 KB	-rw-r--r--
rpl_mts_transaction_retry.inc	7.9 KB	-rw-r--r--
rpl_multi_query.test	782 B	-rw-r--r--
rpl_multi_source_corrupt_repos...	18.31 KB	-rw-r--r--
rpl_multi_source_generate_mts_...	2.11 KB	-rw-r--r--
rpl_multi_update.test	805 B	-rw-r--r--
rpl_multi_update2.test	1.35 KB	-rw-r--r--
rpl_multi_update3.test	4.52 KB	-rw-r--r--
rpl_not_null.test	10.76 KB	-rw-r--r--
rpl_parallel_ddl.test	5.35 KB	-rw-r--r--
rpl_parallel_load.test	6.1 KB	-rw-r--r--
rpl_parallel_load_innodb.test	7 KB	-rw-r--r--
rpl_parallel_recovery_core.tes...	6.74 KB	-rw-r--r--
rpl_partition.test	7.88 KB	-rw-r--r--
rpl_perfschema_applier_xa_stat...	2.96 KB	-rw-r--r--
rpl_perfschema_order_by.test	3.12 KB	-rw-r--r--
rpl_record_compare.test	2.1 KB	-rw-r--r--
rpl_relayrotate.test	2.68 KB	-rw-r--r--
rpl_replication_observers_exam...	2.61 KB	-rw-r--r--
rpl_reset_slave.test	3.82 KB	-rw-r--r--
rpl_reset_slave_all_thread_saf...	1.2 KB	-rw-r--r--
rpl_rollback_to_savepoint.inc	7.54 KB	-rw-r--r--
rpl_row_001.test	2.68 KB	-rw-r--r--
rpl_row_UUID.test	2.61 KB	-rw-r--r--
rpl_row_basic.test	24.58 KB	-rw-r--r--
rpl_row_blob.test	5.57 KB	-rw-r--r--
rpl_row_empty_imgs.test	5.69 KB	-rw-r--r--
rpl_row_event_max_size.inc	4.05 KB	-rw-r--r--
rpl_row_func003.test	3.13 KB	-rw-r--r--
rpl_row_idempotency.test	8.39 KB	-rw-r--r--
rpl_row_img.test	8.23 KB	-rw-r--r--
rpl_row_img_blobs.test	5.82 KB	-rw-r--r--
rpl_row_img_diff_indexes.test	9.11 KB	-rw-r--r--
rpl_row_sp002.test	5.26 KB	-rw-r--r--
rpl_row_sp003.test	2.02 KB	-rw-r--r--
rpl_row_sp006.test	2.78 KB	-rw-r--r--
rpl_row_sp007.test	1.5 KB	-rw-r--r--
rpl_row_tabledefs.test	7.97 KB	-rw-r--r--
rpl_seconds_behind_master_mts_...	12.04 KB	-rw-r--r--
rpl_seconds_behind_master_mts_...	10.2 KB	-rw-r--r--
rpl_semi_sync_ack_thread.inc	676 B	-rw-r--r--
rpl_semi_sync_after_sync.test	4.82 KB	-rw-r--r--
rpl_semi_sync_deadlock.test	1.46 KB	-rw-r--r--
rpl_semi_sync_group_commit_dea...	1.71 KB	-rw-r--r--
rpl_set_null.test	2.85 KB	-rw-r--r--
rpl_sp.test	17.69 KB	-rw-r--r--
rpl_split_statements.test	17.96 KB	-rw-r--r--
rpl_start_stop_slave.test	5.4 KB	-rw-r--r--
rpl_stm_EE_err2.test	1.5 KB	-rw-r--r--
rpl_stm_create_if_not_exists.t...	6.87 KB	-rw-r--r--
rpl_stop_middle_group.test	5.17 KB	-rw-r--r--
rpl_stop_slave.test	1.56 KB	-rw-r--r--
rpl_stress_test.inc	2.21 KB	-rw-r--r--
rpl_sv_relay_space.test	921 B	-rw-r--r--
rpl_sync_relay_log_info.inc	9.02 KB	-rw-r--r--
rpl_sync_relay_log_info_assert...	3.23 KB	-rw-r--r--
rpl_temp_error.test	623 B	-rw-r--r--
rpl_temporary.test	10.6 KB	-rw-r--r--
rpl_test_framework.inc	2.42 KB	-rw-r--r--
rpl_tmp_table_and_DDL.test	4.8 KB	-rw-r--r--
rpl_trig004.test	1.7 KB	-rw-r--r--
rpl_truncate.test	425 B	-rw-r--r--
rpl_truncate_helper.test	976 B	-rw-r--r--
rpl_trx_boundary_parser.inc	1.59 KB	-rw-r--r--
rpl_trx_boundary_parser_all_st...	7.19 KB	-rw-r--r--
rpl_trx_boundary_parser_one_st...	3.69 KB	-rw-r--r--
rpl_trx_boundary_parser_warnin...	4.51 KB	-rw-r--r--
rpl_variables_stm.test	24.26 KB	-rw-r--r--
rpl_xa_gtid_next.inc	2.46 KB	-rw-r--r--
rpl_xa_mixed_engines.inc	1.89 KB	-rw-r--r--
type_conversions.test	23.7 KB	-rw-r--r--

Code Editor : rpl_variables_stm.test

# ==== Purpose ====
#
# In general, queries referencing @@system_variables are not
# considered safe to write to the binlog in statement-based logging
# mode.  However, a few special cases are supported.
#
# This test verifies that queries referencing these specially
# supported variables are replicated correctly in statement mode.
#
#
# ==== Method ====
#
# The test simply does a lot of "INSERT INTO t1 VALUES (@@variable)"
# and checks the result on the slave.
#
# Statements referencing a variable only replicate correctly in mixed
# and row mode: in row mode, the values inserted are replicated.  In
# mixed mode, statements referencing a variable are marked as unsafe,
# meaning they will be replicated by row.  In statement mode, the
# slave's value will be used and replication will break. (Except in a
# small number of special cases: random seeds, insert_id, and
# auto_increment are replicated).
#
# We test all replicated variables, from each of the following
# contexts:
#  - directly
#  - from a stored procedure
#  - from a stored function
#  - from a trigger
#  - from a prepared statement
#
# For all variables where it is possible, we set the variable to one
# value on slave, and insert it on the master with two distinct
# values.
#
# The same insertions are made in four different tables using direct
# insert, stored procedure, stored function, or trigger.  Then all
# eight resulting tables on master and slave are compared.
#
#
# ==== Related bugs ====
#
# BUG#31168: @@hostname does not replicate
#
#
# ==== Related test cases ====
#
# binlog.binlog_unsafe tests that a warning is issued if system
# variables are replicated in statement mode.
#
# rpl.rpl_variables verifies that variables which cannot be replicated
# safely in statement mode are replicated correctly in mixed or row
# mode.

source include/master-slave.inc;
source include/have_binlog_format_mixed_or_statement.inc;

call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");

--echo ==== Initialization ====

# Backup the values of global variables so that they can be restored
# later.

--echo [on master]
connection master;
SET @m_auto_increment_increment= @@global.auto_increment_increment;
SET @m_auto_increment_offset=    @@global.auto_increment_offset;
SET @m_character_set_client=     @@global.character_set_client;
SET @m_collation_connection=     @@global.collation_connection;
SET @m_collation_server=         @@global.collation_server;
SET @m_time_zone=                @@global.time_zone;
SET @m_lc_time_names=            @@global.lc_time_names;
SET @m_collation_database=       @@global.collation_database;

--echo [on slave]
connection slave;
SET @s_auto_increment_increment= @@global.auto_increment_increment;
SET @s_auto_increment_offset=    @@global.auto_increment_offset;
SET @s_character_set_client=     @@global.character_set_client;
SET @s_collation_connection=     @@global.collation_connection;
SET @s_collation_server=         @@global.collation_server;
SET @s_time_zone=                @@global.time_zone;
SET @s_lc_time_names=            @@global.lc_time_names;
SET @s_collation_database=       @@global.collation_database;

SET @@global.auto_increment_increment=19;
SET @@global.auto_increment_offset=4;
SET @@global.character_set_client='latin2';
SET @@global.collation_connection='latin2_bin';
SET @@global.collation_server='geostd8_general_ci';
SET @@global.time_zone='Japan';
SET @@global.lc_time_names='sv_SE';
SET @@global.collation_database='geostd8_bin';

--echo [on master]
connection master;

# Tables where everything happens.
eval CREATE TABLE tstmt (id INT AUTO_INCREMENT PRIMARY KEY,
                    num INT,
                    text VARCHAR(100)) ENGINE=$DEFAULT_ENGINE;
CREATE TABLE tproc LIKE tstmt;
CREATE TABLE tfunc LIKE tstmt;
CREATE TABLE ttrig LIKE tstmt;
CREATE TABLE tprep LIKE tstmt;

# Table on which we put a trigger.
eval CREATE TABLE trigger_table (text CHAR(4)) ENGINE=$DEFAULT_ENGINE;

--echo ==== Insert variables directly ====

SET @@pseudo_thread_id= 4712;
INSERT INTO tstmt(num)  VALUES (@@session.pseudo_thread_id);
SET @@pseudo_thread_id= 4713;
INSERT INTO tstmt(num)  VALUES (@@session.pseudo_thread_id);

SET @@foreign_key_checks= 0;
INSERT INTO tstmt(num)  VALUES (@@session.foreign_key_checks);
SET @@foreign_key_checks= 1;
INSERT INTO tstmt(num)  VALUES (@@session.foreign_key_checks);

SET @@sql_auto_is_null= 0;
INSERT INTO tstmt(num)  VALUES (@@session.sql_auto_is_null);
SET @@sql_auto_is_null= 1;
INSERT INTO tstmt(num)  VALUES (@@session.sql_auto_is_null);

SET @@unique_checks= 0;
INSERT INTO tstmt(num)  VALUES (@@session.unique_checks);
SET @@unique_checks= 1;
INSERT INTO tstmt(num)  VALUES (@@session.unique_checks);

SET @@auto_increment_increment= 11;
INSERT INTO tstmt(num)  VALUES (@@session.auto_increment_increment);
SET @@auto_increment_increment= 19;
INSERT INTO tstmt(num)  VALUES (@@session.auto_increment_increment);

SET @@auto_increment_offset= 13;
INSERT INTO tstmt(num)  VALUES (@@session.auto_increment_offset);
SET @@auto_increment_offset= 17;
INSERT INTO tstmt(num)  VALUES (@@session.auto_increment_offset);

# reset these as they affect the index column
SET @@auto_increment_increment= 1;
SET @@auto_increment_offset= 1;

SET @@character_set_client= 'cp1257';
INSERT INTO tstmt(text) VALUES (@@session.character_set_client);
SET @@character_set_client= 'cp1256';
INSERT INTO tstmt(text) VALUES (@@session.character_set_client);

SET @@collation_connection= 'cp1251_ukrainian_ci';
INSERT INTO tstmt(text) VALUES (@@session.collation_connection);
INSERT INTO tstmt(text) VALUES (@@session.character_set_connection);
SET @@collation_connection= 'cp1251_bulgarian_ci';
INSERT INTO tstmt(text) VALUES (@@session.collation_connection);
INSERT INTO tstmt(text) VALUES (@@session.character_set_connection);

SET @@collation_server= 'latin7_bin';
INSERT INTO tstmt(text) VALUES (@@session.collation_server);
INSERT INTO tstmt(text) VALUES (@@session.character_set_server);
SET @@collation_server= 'latin7_general_cs';
INSERT INTO tstmt(text) VALUES (@@session.collation_server);
INSERT INTO tstmt(text) VALUES (@@session.character_set_server);

SET @@time_zone= 'Europe/Moscow';
INSERT INTO tstmt(text) VALUES (@@session.time_zone);
SET @@time_zone= 'Universal';
INSERT INTO tstmt(text) VALUES (@@session.time_zone);

SET @@lc_time_names= 'sv_FI';
INSERT INTO tstmt(text) VALUES (@@session.lc_time_names);
SET @@lc_time_names= 'no_NO';
INSERT INTO tstmt(text) VALUES (@@session.lc_time_names);

SET @@collation_database= 'latin7_general_ci';
INSERT INTO tstmt(text) VALUES (@@session.collation_database);
INSERT INTO tstmt(text) VALUES (@@session.character_set_database);
SET @@collation_database= 'latin7_estonian_cs';
INSERT INTO tstmt(text) VALUES (@@session.collation_database);
INSERT INTO tstmt(text) VALUES (@@session.character_set_database);

SET @@timestamp= 47114711;
INSERT INTO tstmt(text) VALUES (@@session.timestamp);
SET @@timestamp= 47124712;
INSERT INTO tstmt(text) VALUES (@@session.timestamp);

SET @@last_insert_id= 1616;
INSERT INTO tstmt(text) VALUES (@@session.last_insert_id);
SET @@last_insert_id= 1717;
INSERT INTO tstmt(text) VALUES (@@session.last_insert_id);

--echo ==== Insert variables from a stored procedure ====

DELIMITER |;
CREATE PROCEDURE proc()
BEGIN

SET @@pseudo_thread_id= 4712;
  INSERT INTO tproc(num)  VALUES (@@session.pseudo_thread_id);
  SET @@pseudo_thread_id= 4713;
  INSERT INTO tproc(num)  VALUES (@@session.pseudo_thread_id);

SET @@foreign_key_checks= 0;
  INSERT INTO tproc(num)  VALUES (@@session.foreign_key_checks);
  SET @@foreign_key_checks= 1;
  INSERT INTO tproc(num)  VALUES (@@session.foreign_key_checks);

SET @@sql_auto_is_null= 0;
  INSERT INTO tproc(num)  VALUES (@@session.sql_auto_is_null);
  SET @@sql_auto_is_null= 1;
  INSERT INTO tproc(num)  VALUES (@@session.sql_auto_is_null);

SET @@unique_checks= 0;
  INSERT INTO tproc(num)  VALUES (@@session.unique_checks);
  SET @@unique_checks= 1;
  INSERT INTO tproc(num)  VALUES (@@session.unique_checks);

SET @@auto_increment_increment= 11;
  INSERT INTO tproc(num)  VALUES (@@session.auto_increment_increment);
  SET @@auto_increment_increment= 19;
  INSERT INTO tproc(num)  VALUES (@@session.auto_increment_increment);

SET @@auto_increment_offset= 13;
  INSERT INTO tproc(num)  VALUES (@@session.auto_increment_offset);
  SET @@auto_increment_offset= 17;
  INSERT INTO tproc(num)  VALUES (@@session.auto_increment_offset);

# reset these as they affect the index column
  SET @@auto_increment_increment= 1;
  SET @@auto_increment_offset= 1;

SET @@character_set_client= 'cp1257';
  INSERT INTO tproc(text) VALUES (@@session.character_set_client);
  SET @@character_set_client= 'cp1256';
  INSERT INTO tproc(text) VALUES (@@session.character_set_client);

SET @@collation_connection= 'cp1251_ukrainian_ci';
  INSERT INTO tproc(text) VALUES (@@session.collation_connection);
  INSERT INTO tproc(text) VALUES (@@session.character_set_connection);
  SET @@collation_connection= 'cp1251_bulgarian_ci';
  INSERT INTO tproc(text) VALUES (@@session.collation_connection);
  INSERT INTO tproc(text) VALUES (@@session.character_set_connection);

SET @@collation_server= 'latin7_bin';
  INSERT INTO tproc(text) VALUES (@@session.collation_server);
  INSERT INTO tproc(text) VALUES (@@session.character_set_server);
  SET @@collation_server= 'latin7_general_cs';
  INSERT INTO tproc(text) VALUES (@@session.collation_server);
  INSERT INTO tproc(text) VALUES (@@session.character_set_server);

SET @@time_zone= 'Europe/Moscow';
  INSERT INTO tproc(text) VALUES (@@session.time_zone);
  SET @@time_zone= 'Universal';
  INSERT INTO tproc(text) VALUES (@@session.time_zone);

SET @@lc_time_names= 'sv_FI';
  INSERT INTO tproc(text) VALUES (@@session.lc_time_names);
  SET @@lc_time_names= 'no_NO';
  INSERT INTO tproc(text) VALUES (@@session.lc_time_names);

SET @@collation_database= 'latin7_general_ci';
  INSERT INTO tproc(text) VALUES (@@session.collation_database);
  INSERT INTO tproc(text) VALUES (@@session.character_set_database);
  SET @@collation_database= 'latin7_estonian_cs';
  INSERT INTO tproc(text) VALUES (@@session.collation_database);
  INSERT INTO tproc(text) VALUES (@@session.character_set_database);

SET @@timestamp= 47114711;
  INSERT INTO tproc(text) VALUES (@@session.timestamp);
  SET @@timestamp= 47124712;
  INSERT INTO tproc(text) VALUES (@@session.timestamp);

SET @@last_insert_id= 1616;
  INSERT INTO tproc(text) VALUES (@@session.last_insert_id);
  SET @@last_insert_id= 1717;
  INSERT INTO tproc(text) VALUES (@@session.last_insert_id);

END|
DELIMITER ;|

CALL proc();

--echo ==== Insert variables from a stored function ====

DELIMITER |;
CREATE FUNCTION func()
RETURNS INT
BEGIN

SET @@pseudo_thread_id= 4712;
  INSERT INTO tfunc(num)  VALUES (@@session.pseudo_thread_id);
  SET @@pseudo_thread_id= 4713;
  INSERT INTO tfunc(num)  VALUES (@@session.pseudo_thread_id);

SET @@foreign_key_checks= 0;
  INSERT INTO tfunc(num)  VALUES (@@session.foreign_key_checks);
  SET @@foreign_key_checks= 1;
  INSERT INTO tfunc(num)  VALUES (@@session.foreign_key_checks);

SET @@sql_auto_is_null= 0;
  INSERT INTO tfunc(num)  VALUES (@@session.sql_auto_is_null);
  SET @@sql_auto_is_null= 1;
  INSERT INTO tfunc(num)  VALUES (@@session.sql_auto_is_null);

SET @@unique_checks= 0;
  INSERT INTO tfunc(num)  VALUES (@@session.unique_checks);
  SET @@unique_checks= 1;
  INSERT INTO tfunc(num)  VALUES (@@session.unique_checks);

SET @@auto_increment_increment= 11;
  INSERT INTO tfunc(num)  VALUES (@@session.auto_increment_increment);
  SET @@auto_increment_increment= 19;
  INSERT INTO tfunc(num)  VALUES (@@session.auto_increment_increment);

SET @@auto_increment_offset= 13;
  INSERT INTO tfunc(num)  VALUES (@@session.auto_increment_offset);
  SET @@auto_increment_offset= 17;
  INSERT INTO tfunc(num)  VALUES (@@session.auto_increment_offset);

# reset these as they affect the index column
  SET @@auto_increment_increment= 1;
  SET @@auto_increment_offset= 1;

SET @@character_set_client= 'cp1257';
  INSERT INTO tfunc(text) VALUES (@@session.character_set_client);
  SET @@character_set_client= 'cp1256';
  INSERT INTO tfunc(text) VALUES (@@session.character_set_client);

SET @@collation_connection= 'cp1251_ukrainian_ci';
  INSERT INTO tfunc(text) VALUES (@@session.collation_connection);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_connection);
  SET @@collation_connection= 'cp1251_bulgarian_ci';
  INSERT INTO tfunc(text) VALUES (@@session.collation_connection);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_connection);

SET @@collation_server= 'latin7_bin';
  INSERT INTO tfunc(text) VALUES (@@session.collation_server);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_server);
  SET @@collation_server= 'latin7_general_cs';
  INSERT INTO tfunc(text) VALUES (@@session.collation_server);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_server);

SET @@time_zone= 'Europe/Moscow';
  INSERT INTO tfunc(text) VALUES (@@session.time_zone);
  SET @@time_zone= 'Universal';
  INSERT INTO tfunc(text) VALUES (@@session.time_zone);

SET @@lc_time_names= 'sv_FI';
  INSERT INTO tfunc(text) VALUES (@@session.lc_time_names);
  SET @@lc_time_names= 'no_NO';
  INSERT INTO tfunc(text) VALUES (@@session.lc_time_names);

SET @@collation_database= 'latin7_general_ci';
  INSERT INTO tfunc(text) VALUES (@@session.collation_database);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_database);
  SET @@collation_database= 'latin7_estonian_cs';
  INSERT INTO tfunc(text) VALUES (@@session.collation_database);
  INSERT INTO tfunc(text) VALUES (@@session.character_set_database);

SET @@timestamp= 47114711;
  INSERT INTO tfunc(text) VALUES (@@session.timestamp);
  SET @@timestamp= 47124712;
  INSERT INTO tfunc(text) VALUES (@@session.timestamp);

SET @@last_insert_id= 1616;
  INSERT INTO tfunc(text) VALUES (@@session.last_insert_id);
  SET @@last_insert_id= 1717;
  INSERT INTO tfunc(text) VALUES (@@session.last_insert_id);

RETURN 0;
END|
DELIMITER ;|

--disable_warnings
SELECT func();
--enable_warnings

--echo ==== Insert variables from a trigger ====

DELIMITER |;
CREATE TRIGGER trig
BEFORE INSERT ON trigger_table
FOR EACH ROW
BEGIN

SET @@pseudo_thread_id= 4712;
  INSERT INTO ttrig(num)  VALUES (@@session.pseudo_thread_id);
  SET @@pseudo_thread_id= 4713;
  INSERT INTO ttrig(num)  VALUES (@@session.pseudo_thread_id);

SET @@foreign_key_checks= 0;
  INSERT INTO ttrig(num)  VALUES (@@session.foreign_key_checks);
  SET @@foreign_key_checks= 1;
  INSERT INTO ttrig(num)  VALUES (@@session.foreign_key_checks);

SET @@sql_auto_is_null= 0;
  INSERT INTO ttrig(num)  VALUES (@@session.sql_auto_is_null);
  SET @@sql_auto_is_null= 1;
  INSERT INTO ttrig(num)  VALUES (@@session.sql_auto_is_null);

SET @@unique_checks= 0;
  INSERT INTO ttrig(num)  VALUES (@@session.unique_checks);
  SET @@unique_checks= 1;
  INSERT INTO ttrig(num)  VALUES (@@session.unique_checks);

SET @@auto_increment_increment= 11;
  INSERT INTO ttrig(num)  VALUES (@@session.auto_increment_increment);
  SET @@auto_increment_increment= 19;
  INSERT INTO ttrig(num)  VALUES (@@session.auto_increment_increment);

SET @@auto_increment_offset= 13;
  INSERT INTO ttrig(num)  VALUES (@@session.auto_increment_offset);
  SET @@auto_increment_offset= 17;
  INSERT INTO ttrig(num)  VALUES (@@session.auto_increment_offset);

# reset these as they affect the index column
  SET @@auto_increment_increment= 1;
  SET @@auto_increment_offset= 1;

SET @@character_set_client= 'cp1257';
  INSERT INTO ttrig(text) VALUES (@@session.character_set_client);
  SET @@character_set_client= 'cp1256';
  INSERT INTO ttrig(text) VALUES (@@session.character_set_client);

SET @@collation_connection= 'cp1251_ukrainian_ci';
  INSERT INTO ttrig(text) VALUES (@@session.collation_connection);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_connection);
  SET @@collation_connection= 'cp1251_bulgarian_ci';
  INSERT INTO ttrig(text) VALUES (@@session.collation_connection);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_connection);

SET @@collation_server= 'latin7_bin';
  INSERT INTO ttrig(text) VALUES (@@session.collation_server);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_server);
  SET @@collation_server= 'latin7_general_cs';
  INSERT INTO ttrig(text) VALUES (@@session.collation_server);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_server);

SET @@time_zone= 'Europe/Moscow';
  INSERT INTO ttrig(text) VALUES (@@session.time_zone);
  SET @@time_zone= 'Universal';
  INSERT INTO ttrig(text) VALUES (@@session.time_zone);

SET @@lc_time_names= 'sv_FI';
  INSERT INTO ttrig(text) VALUES (@@session.lc_time_names);
  SET @@lc_time_names= 'no_NO';
  INSERT INTO ttrig(text) VALUES (@@session.lc_time_names);

SET @@collation_database= 'latin7_general_ci';
  INSERT INTO ttrig(text) VALUES (@@session.collation_database);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_database);
  SET @@collation_database= 'latin7_estonian_cs';
  INSERT INTO ttrig(text) VALUES (@@session.collation_database);
  INSERT INTO ttrig(text) VALUES (@@session.character_set_database);

SET @@timestamp= 47114711;
  INSERT INTO ttrig(text) VALUES (@@session.timestamp);
  SET @@timestamp= 47124712;
  INSERT INTO ttrig(text) VALUES (@@session.timestamp);

SET @@last_insert_id= 1616;
  INSERT INTO ttrig(text) VALUES (@@session.last_insert_id);
  SET @@last_insert_id= 1717;
  INSERT INTO ttrig(text) VALUES (@@session.last_insert_id);

END|
DELIMITER ;|

--disable_warnings
INSERT INTO trigger_table VALUES ('bye.');
--enable_warnings

--echo ==== Insert variables from a prepared statement ====

# GLOBAL

PREPARE p1 FROM 'SET @@pseudo_thread_id= 4712';
PREPARE p2 FROM 'INSERT INTO tprep(num)  VALUES (@@session.pseudo_thread_id)';
PREPARE p3 FROM 'SET @@pseudo_thread_id= 4713';
PREPARE p4 FROM 'INSERT INTO tprep(num)  VALUES (@@session.pseudo_thread_id)';

PREPARE p5 FROM 'SET @@foreign_key_checks= 0';
PREPARE p6 FROM 'INSERT INTO tprep(num)  VALUES (@@session.foreign_key_checks)';
PREPARE p7 FROM 'SET @@foreign_key_checks= 1';
PREPARE p8 FROM 'INSERT INTO tprep(num)  VALUES (@@session.foreign_key_checks)';

PREPARE p9 FROM 'SET @@sql_auto_is_null= 0';
PREPARE p10 FROM 'INSERT INTO tprep(num)  VALUES (@@session.sql_auto_is_null)';
PREPARE p11 FROM 'SET @@sql_auto_is_null= 1';
PREPARE p12 FROM 'INSERT INTO tprep(num)  VALUES (@@session.sql_auto_is_null)';

PREPARE p13 FROM 'SET @@unique_checks= 0';
PREPARE p14 FROM 'INSERT INTO tprep(num)  VALUES (@@session.unique_checks)';
PREPARE p15 FROM 'SET @@unique_checks= 1';
PREPARE p16 FROM 'INSERT INTO tprep(num)  VALUES (@@session.unique_checks)';

PREPARE p17 FROM 'SET @@auto_increment_increment= 11';
PREPARE p18 FROM 'INSERT INTO tprep(num)  VALUES (@@session.auto_increment_increment)';
PREPARE p19 FROM 'SET @@auto_increment_increment= 19';
PREPARE p20 FROM 'INSERT INTO tprep(num)  VALUES (@@session.auto_increment_increment)';

PREPARE p21 FROM 'SET @@auto_increment_offset= 13';
PREPARE p22 FROM 'INSERT INTO tprep(num)  VALUES (@@session.auto_increment_offset)';
PREPARE p23 FROM 'SET @@auto_increment_offset= 17';
PREPARE p24 FROM 'INSERT INTO tprep(num)  VALUES (@@session.auto_increment_offset)';

# reset these as they affect the index column
PREPARE p25 FROM 'SET @@auto_increment_increment= 1';
PREPARE p26 FROM 'SET @@auto_increment_offset= 1';

PREPARE p27 FROM 'SET @@character_set_client= \'cp1257\'';
PREPARE p28 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)';
PREPARE p29 FROM 'SET @@character_set_client= \'cp1256\'';
PREPARE p30 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)';

PREPARE p31 FROM 'SET @@collation_connection= \'cp1251_ukrainian_ci\'';
PREPARE p32 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)';
PREPARE p33 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)';
PREPARE p34 FROM 'SET @@collation_connection= \'cp1251_bulgarian_ci\'';
PREPARE p35 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)';
PREPARE p36 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)';

PREPARE p37 FROM 'SET @@collation_server= \'latin7_bin\'';
PREPARE p38 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)';
PREPARE p39 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)';
PREPARE p40 FROM 'SET @@collation_server= \'latin7_general_cs\'';
PREPARE p41 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)';
PREPARE p42 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)';

PREPARE p43 FROM 'SET @@time_zone= \'Europe/Moscow\'';
PREPARE p44 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)';
PREPARE p45 FROM 'SET @@time_zone= \'Universal\'';
PREPARE p46 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)';

PREPARE p47 FROM 'SET @@lc_time_names= \'sv_FI\'';
PREPARE p48 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)';
PREPARE p49 FROM 'SET @@lc_time_names= \'no_NO\'';
PREPARE p50 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)';

PREPARE p51 FROM 'SET @@collation_database= \'latin7_general_ci\'';
PREPARE p52 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)';
PREPARE p53 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)';
PREPARE p54 FROM 'SET @@collation_database= \'latin7_estonian_cs\'';
PREPARE p55 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)';
PREPARE p56 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)';

PREPARE p57 FROM 'SET @@timestamp= 47114711';
PREPARE p58 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)';
PREPARE p59 FROM 'SET @@timestamp= 47124712';
PREPARE p60 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)';

PREPARE p61 FROM 'SET @@last_insert_id= 1616';
PREPARE p62 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)';
PREPARE p63 FROM 'SET @@last_insert_id= 1717';
PREPARE p64 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)';

EXECUTE p1;  EXECUTE p2;  EXECUTE p3;  EXECUTE p4;  EXECUTE p5;  EXECUTE p6;
EXECUTE p7;  EXECUTE p8;  EXECUTE p9;  EXECUTE p10; EXECUTE p11; EXECUTE p12;
EXECUTE p13; EXECUTE p14; EXECUTE p15; EXECUTE p16; EXECUTE p17; EXECUTE p18;
EXECUTE p19; EXECUTE p20; EXECUTE p21; EXECUTE p22; EXECUTE p23; EXECUTE p24;
EXECUTE p25; EXECUTE p26; EXECUTE p27; EXECUTE p28; EXECUTE p29; EXECUTE p30;
EXECUTE p31; EXECUTE p32; EXECUTE p33; EXECUTE p34; EXECUTE p35; EXECUTE p36;
EXECUTE p37; EXECUTE p38; EXECUTE p39; EXECUTE p40; EXECUTE p41; EXECUTE p42;
EXECUTE p43; EXECUTE p44; EXECUTE p45; EXECUTE p46; EXECUTE p47; EXECUTE p48;
EXECUTE p49; EXECUTE p50; EXECUTE p51; EXECUTE p52; EXECUTE p53; EXECUTE p54;
EXECUTE p55; EXECUTE p56; EXECUTE p57; EXECUTE p58; EXECUTE p59; EXECUTE p60;
EXECUTE p61; EXECUTE p62; EXECUTE p63; EXECUTE p64;

--sync_slave_with_master
--connection master

--echo ==== Results ====

# Show the result in table test.tstmt on master...
SELECT * FROM tstmt ORDER BY id;

--sync_slave_with_master

# ... then compare test.tstmt on master to the other tables on master and slave.
let $diff_tables= master:tstmt, master:tproc, master:tfunc, master:ttrig, master:tprep, slave:tstmt, slave:tproc, slave:tfunc, slave:ttrig, slave:tprep;
source include/diff_tables.inc;

--echo ==== Clean up ====

--echo [on master]
connection master;
DROP PROCEDURE proc;
DROP FUNCTION func;
DROP TRIGGER trig;
DROP TABLE tstmt, tproc, tfunc, ttrig, tprep, trigger_table;

SET @@global.auto_increment_increment= @m_auto_increment_increment;
SET @@global.auto_increment_offset=    @m_auto_increment_offset;
SET @@global.character_set_client=     @m_character_set_client;
SET @@global.collation_connection=     @m_collation_connection;
SET @@global.collation_server=         @m_collation_server;
SET @@global.time_zone=                @m_time_zone;
SET @@global.lc_time_names=            @m_lc_time_names;
SET @@global.collation_database=       @m_collation_database;

--echo [on slave]
connection slave;
SET @@global.auto_increment_increment= @s_auto_increment_increment;
SET @@global.auto_increment_offset=    @s_auto_increment_offset;
SET @@global.character_set_client=     @s_character_set_client;
SET @@global.collation_connection=     @s_collation_connection;
SET @@global.collation_server=         @s_collation_server;
SET @@global.time_zone=                @s_time_zone;
SET @@global.lc_time_names=            @s_lc_time_names;
SET @@global.collation_database=       @s_collation_database;

connection master;
sync_slave_with_master;
--source include/rpl_end.inc

${this.title}

Code Editor : rpl_variables_stm.test