63 lines
1.6 KiB
Plaintext
63 lines
1.6 KiB
Plaintext
############################################################
|
|
# Purpose: WL#5223. Testing BGC options
|
|
# Author: Serge Kozlov <serge.kozlov@oracle.com>
|
|
# Purpose: Execute server code related to BGC options.
|
|
# We do not test here the functionality of new
|
|
# options because of it requires a complex
|
|
# test with debug-sync and just make sure
|
|
# that there is no crash/assertion when
|
|
# that code executed.
|
|
############################################################
|
|
--source include/not_group_replication_plugin.inc
|
|
source include/master-slave.inc;
|
|
|
|
# Settings
|
|
let $loop_counter= 100;
|
|
|
|
--disable_query_log
|
|
# Create table
|
|
echo # Create table;
|
|
CREATE TABLE t (a INT NOT NULL, b VARCHAR(200), c TEXT, d DATETIME NOT NULL, e BIGINT NOT NULL, KEY(d,e)) ENGINE=InnoDB;
|
|
|
|
# Create connections
|
|
echo # Create connections;
|
|
connect(conn_1,localhost,root,,);
|
|
connect(conn_2,localhost,root,,);
|
|
|
|
# Main test
|
|
echo # Insert rows;
|
|
disable_query_log;
|
|
disable_result_log;
|
|
while ($loop_counter) {
|
|
connection conn_1;
|
|
send INSERT INTO t VALUES (1, '', REPEAT('a', 1), NOW(), 1);
|
|
connection conn_2;
|
|
send INSERT INTO t VALUES (1, '', REPEAT('a', 1), NOW(), 1);
|
|
connection conn_1;
|
|
reap;
|
|
connection conn_2;
|
|
reap;
|
|
dec $loop_counter;
|
|
}
|
|
enable_result_log;
|
|
enable_query_log;
|
|
|
|
# Results
|
|
echo # Master results;
|
|
connection master;
|
|
SELECT COUNT(a) FROM t;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
echo # Slave results;
|
|
SELECT COUNT(a) FROM t;
|
|
|
|
# Clean up
|
|
echo # Clean up;
|
|
connection master;
|
|
DROP TABLE t;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
source include/stop_slave.inc;
|
|
|
|
--let $rpl_only_running_threads = 1;
|
|
--source include/rpl_end.inc
|
|
echo # End of tests;
|