Debian Codegraph @

mysql-test/suite/sys_vars/r/skip_replica_start.result

raw
1 include/assert.inc [Default GLOBAL value is FALSE]
2 SET PERSIST_ONLY skip_replica_start = ON;
3 # restart
4 include/assert.inc [Reported value matches the one set (set ON in PERSIST_ONLY scope)]
5 SET PERSIST_ONLY skip_replica_start = OFF;
6 # restart
7 include/assert.inc [Reported value matches the one set (set OFF in PERSIST_ONLY scope)]
8 SET PERSIST_ONLY skip_replica_start = TRUE;
9 # restart
10 include/assert.inc [Reported value matches the one set (set TRUE in PERSIST_ONLY scope)]
11 SET PERSIST_ONLY skip_replica_start = FALSE;
12 # restart
13 include/assert.inc [Reported value matches the one set (set FALSE in PERSIST_ONLY scope)]
14 SET PERSIST_ONLY skip_replica_start = 1;
15 # restart
16 include/assert.inc [Reported value matches the one set (set 1 in PERSIST_ONLY scope)]
17 SET PERSIST_ONLY skip_replica_start = 0;
18 # restart
19 include/assert.inc [Reported value matches the one set (set 0 in PERSIST_ONLY scope)]
20 RESET PERSIST skip_replica_start;
21 # restart: --skip-replica-start=ON
22 include/assert.inc [Reported value matches the one set (set ON in `--skip-replica-start` parameter)]
23 # restart: --skip-replica-start=OFF
24 include/assert.inc [Reported value matches the one set (set OFF in `--skip-replica-start` parameter)]
25 # restart: --skip-replica-start=TRUE
26 include/assert.inc [Reported value matches the one set (set TRUE in `--skip-replica-start` parameter)]
27 # restart: --skip-replica-start=FALSE
28 include/assert.inc [Reported value matches the one set (set FALSE in `--skip-replica-start` parameter)]
29 # restart: --skip-replica-start=1
30 include/assert.inc [Reported value matches the one set (set 1 in `--skip-replica-start` parameter)]
31 # restart: --skip-replica-start=0
32 include/assert.inc [Reported value matches the one set (set 0 in `--skip-replica-start` parameter)]
33 CREATE USER user1;
34 SET PERSIST_ONLY skip_replica_start = 1;
35 ERROR 42000: Access denied; you need SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges for this operation
36 GRANT SYSTEM_VARIABLES_ADMIN, PERSIST_RO_VARIABLES_ADMIN ON *.* TO user1@'%';
37 FLUSH PRIVILEGES;
38 SET PERSIST_ONLY skip_replica_start = 1;
39 DROP USER user1;
40 RESET PERSIST skip_replica_start;
41 BEGIN;
42 SET PERSIST_ONLY skip_replica_start = ON;
43 ROLLBACK;
44 RESET PERSIST skip_replica_start;