Debian Codegraph @

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

raw
1 SET @start_value = @@global.automatic_sp_privileges;
2 SELECT @start_value;
3 @start_value
4 1
5 '#--------------------FN_DYNVARS_004_01------------------------#'
6 SET @@global.automatic_sp_privileges = 0;
7 SET @@global.automatic_sp_privileges = DEFAULT;
8 SELECT @@global.automatic_sp_privileges;
9 @@global.automatic_sp_privileges
10 1
11 '#---------------------FN_DYNVARS_004_02-------------------------#'
12 SET @@global.automatic_sp_privileges = @start_value;
13 SELECT @@global.automatic_sp_privileges = TRUE;
14 @@global.automatic_sp_privileges = TRUE
15 1
16 '#--------------------FN_DYNVARS_004_03------------------------#'
17 SET @@global.automatic_sp_privileges = 0;
18 SELECT @@global.automatic_sp_privileges;
19 @@global.automatic_sp_privileges
20 0
21 SET @@global.automatic_sp_privileges = 1;
22 SELECT @@global.automatic_sp_privileges;
23 @@global.automatic_sp_privileges
24 1
25 '#--------------------FN_DYNVARS_004_04-------------------------#'
26 SET @@global.automatic_sp_privileges = 2;
27 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '2'
28 SET @@global.automatic_sp_privileges = -1;
29 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '-1'
30 SET @@global.automatic_sp_privileges = TRUEF;
31 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'TRUEF'
32 SET @@global.automatic_sp_privileges = TRUE_F;
33 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'TRUE_F'
34 SET @@global.automatic_sp_privileges = FALSE0;
35 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'FALSE0'
36 SET @@global.automatic_sp_privileges = OON;
37 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'OON'
38 SET @@global.automatic_sp_privileges = ONN;
39 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'ONN'
40 SET @@global.automatic_sp_privileges = OOFF;
41 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'OOFF'
42 SET @@global.automatic_sp_privileges = 0FF;
43 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '0FF'
44 SET @@global.automatic_sp_privileges = ' ';
45 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of ' '
46 SET @@global.automatic_sp_privileges = " ";
47 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of ' '
48 SET @@global.automatic_sp_privileges = '';
49 ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of ''
50 '#-------------------FN_DYNVARS_004_05----------------------------#'
51 SET @@session.automatic_sp_privileges = 1;
52 ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable and should be set with SET GLOBAL
53 SELECT @@session.automatic_sp_privileges;
54 ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable
55 '#----------------------FN_DYNVARS_004_06------------------------#'
56 SELECT IF(@@global.automatic_sp_privileges, "ON", "OFF") = VARIABLE_VALUE
57 FROM performance_schema.global_variables
58 WHERE VARIABLE_NAME='automatic_sp_privileges';
59 IF(@@global.automatic_sp_privileges, "ON", "OFF") = VARIABLE_VALUE
60 1
61 '#---------------------FN_DYNVARS_004_07----------------------#'
62 SET @@global.automatic_sp_privileges = OFF;
63 SELECT @@global.automatic_sp_privileges;
64 @@global.automatic_sp_privileges
65 0
66 SET @@global.automatic_sp_privileges = ON;
67 SELECT @@global.automatic_sp_privileges;
68 @@global.automatic_sp_privileges
69 1
70 '#---------------------FN_DYNVARS_004_08----------------------#'
71 SET @@global.automatic_sp_privileges = TRUE;
72 SELECT @@global.automatic_sp_privileges;
73 @@global.automatic_sp_privileges
74 1
75 SET @@global.automatic_sp_privileges = FALSE;
76 SELECT @@global.automatic_sp_privileges;
77 @@global.automatic_sp_privileges
78 0
79 '#---------------------FN_DYNVARS_004_09----------------------#'
80 SET @@global.automatic_sp_privileges = 1;
81 SELECT @@automatic_sp_privileges = @@global.automatic_sp_privileges;
82 @@automatic_sp_privileges = @@global.automatic_sp_privileges
83 1
84 '#---------------------FN_DYNVARS_004_10----------------------#'
85 SET automatic_sp_privileges = 1;
86 ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable and should be set with SET GLOBAL
87 SET local.automatic_sp_privileges = 1;
88 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.automatic_sp_privileges = 1' at line 1
89 SELECT local.automatic_sp_privileges;
90 ERROR 42S02: Unknown table 'local' in field list
91 SET global.automatic_sp_privileges = 1;
92 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.automatic_sp_privileges = 1' at line 1
93 SELECT global.automatic_sp_privileges;
94 ERROR 42S02: Unknown table 'global' in field list
95 SELECT automatic_sp_privileges;
96 ERROR 42S22: Unknown column 'automatic_sp_privileges' in 'field list'
97 SELECT @@session.automatic_sp_privileges;
98 ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable
99 SET @@global.automatic_sp_privileges = @start_value;
100 SELECT @@global.automatic_sp_privileges;
101 @@global.automatic_sp_privileges
102 1