1
by brian
clean slate |
1 |
# Tests that variables work correctly (setting and showing). This
|
2 |
# test is like the main.variables test, but for variables not
|
|
3 |
# available in embedded mode.
|
|
4 |
||
5 |
--echo ---- Init ---- |
|
6 |
# Backup global variables so they can be restored at end of test.
|
|
7 |
set @my_slave_net_timeout =@@global.slave_net_timeout; |
|
8 |
||
9 |
--echo ---- Test ---- |
|
10 |
set global slave_net_timeout=100; |
|
11 |
set global sql_slave_skip_counter=100; |
|
12 |
||
13 |
# End of 4.1 tests
|
|
14 |
||
15 |
# BUG #7800: Add various-slave related variables to SHOW VARIABLES
|
|
16 |
show variables like 'slave_compressed_protocol'; |
|
17 |
--replace_column 2 SLAVE_LOAD_TMPDIR |
|
18 |
show variables like 'slave_load_tmpdir'; |
|
19 |
# We just set some arbitrary values in variables-master.opt so we can test
|
|
20 |
# that a list of values works correctly
|
|
21 |
show variables like 'slave_skip_errors'; |
|
22 |
||
23 |
--echo ---- Clean Up ---- |
|
24 |
||
25 |
set global slave_net_timeout=default; |
|
26 |
# sql_slave_skip_counter is write-only, so we can't save previous
|
|
27 |
# value and restore it here. That's ok, because it's normally 0.
|
|
28 |
set global sql_slave_skip_counter= 0; |