1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
--echo #
--echo # Bug#26199978 - WRONG ERROR MESSAGE FOR PARTIAL BACKUPS WITH GTID_MODE = ON
--echo #
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart: --enforce-gtid-consistency=ON --gtid-mode=ON" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
let SEARCH_FILE=$MYSQLTEST_VARDIR/tmp/bug26199978_gtid-purged_ON.sql;
let SEARCH_PATTERN=SET @@GLOBAL.GTID_PURGED=.* '.*';
let GREP_FILE=$MYSQLTEST_VARDIR/tmp/bug26199978_gtid-purged_OFF.sql;
let GREP_PATTERN=$SEARCH_PATTERN;
--echo # Test 1: Taking backup when --set-gtid-purged is passed as ON
CREATE DATABASE bug26199978;
--exec $MYSQL_PUMP --databases bug26199978 --set-gtid-purged=ON > $SEARCH_FILE
DROP DATABASE bug26199978;
--echo # Backup file should contain "$SEARCH_PATTERN"
--source include/search_pattern.inc
--echo # Test 2: Taking backup when --set-gtid-purged is pased as OFF
CREATE DATABASE bug26199978;
--exec $MYSQL_PUMP --databases bug26199978 --set-gtid-purged=OFF > $GREP_FILE
DROP DATABASE bug26199978;
--echo # Backup file should NOT contain "$GREP_PATTERN"
--source include/grep_pattern.inc
--echo # Test 3: Taking backup when --set-gtid-purged is passed as AUTO. Should error out
--echo # asking to pass --set-gtid-purged=[ON|OFF]
CREATE DATABASE bug26199978;
--error 1
--exec $MYSQL_PUMP --databases bug26199978 --set-gtid-purged=AUTO > $MYSQLTEST_VARDIR/tmp/bug26199978_auto.sql
DROP DATABASE bug26199978;
--echo # Cleanup
--remove_files_wildcard $MYSQLTEST_VARDIR/tmp bug26199978_*.sql
# Restore default settings
let $restart_parameters = restart:;
--source include/restart_mysqld.inc
|
