Debian Codegraph @

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

raw
1 SET @saved_global_sql_generate_invisible_primary_key = @@global.sql_generate_invisible_primary_key;
2 SET @saved_session_sql_generate_invisible_primary_key = @@session.sql_generate_invisible_primary_key;
3 include/assert.inc [Default GLOBAL value is OFF]
4 include/assert.inc [Default SESSION value is OFF]
5 SET @@SESSION.sql_generate_invisible_primary_key = 0;
6 include/assert.inc [Reported value matches the one set (set 0 in SESSION scope)]
7 SET @@SESSION.sql_generate_invisible_primary_key = DEFAULT;
8 include/assert.inc [Reported value matches the one set (set DEFAULT in SESSION scope)]
9 SET @@SESSION.sql_generate_invisible_primary_key = OFF;
10 include/assert.inc [Reported value matches the one set (set OFF in SESSION scope)]
11 SET @@SESSION.sql_generate_invisible_primary_key = FALSE;
12 include/assert.inc [Reported value matches the one set (set FALSE in SESSION scope)]
13 SET @@SESSION.sql_generate_invisible_primary_key = ON;
14 include/assert.inc [Reported value matches the one set (set ON in SESSION scope)]
15 SET @@SESSION.sql_generate_invisible_primary_key = TRUE;
16 include/assert.inc [Reported value matches the one set (set TRUE in SESSION scope)]
17 SET @@SESSION.sql_generate_invisible_primary_key = 1;
18 include/assert.inc [Reported value matches the one set (set 1 in SESSION scope)]
19 SET @@GLOBAL.sql_generate_invisible_primary_key = 0;
20 include/assert.inc [Reported value matches the one set (set 0 in GLOBAL scope)]
21 SET @@GLOBAL.sql_generate_invisible_primary_key = DEFAULT;
22 include/assert.inc [Reported value matches the one set (set DEFAULT in GLOBAL scope)]
23 SET @@GLOBAL.sql_generate_invisible_primary_key = OFF;
24 include/assert.inc [Reported value matches the one set (set OFF in GLOBAL scope)]
25 SET @@GLOBAL.sql_generate_invisible_primary_key = FALSE;
26 include/assert.inc [Reported value matches the one set (set FALSE in GLOBAL scope)]
27 SET @@GLOBAL.sql_generate_invisible_primary_key = ON;
28 include/assert.inc [Reported value matches the one set (set ON in GLOBAL scope)]
29 SET @@GLOBAL.sql_generate_invisible_primary_key = TRUE;
30 include/assert.inc [Reported value matches the one set (set TRUE in GLOBAL scope)]
31 SET @@GLOBAL.sql_generate_invisible_primary_key = 1;
32 include/assert.inc [Reported value matches the one set (set 1 in GLOBAL scope)]
33 SET @@PERSIST.sql_generate_invisible_primary_key = 0;
34 include/assert.inc [Reported value matches the one set (set 0 in PERSIST scope)]
35 SET @@PERSIST.sql_generate_invisible_primary_key = DEFAULT;
36 include/assert.inc [Reported value matches the one set (set DEFAULT in PERSIST scope)]
37 SET @@PERSIST.sql_generate_invisible_primary_key = OFF;
38 include/assert.inc [Reported value matches the one set (set OFF in PERSIST scope)]
39 SET @@PERSIST.sql_generate_invisible_primary_key = FALSE;
40 include/assert.inc [Reported value matches the one set (set FALSE in PERSIST scope)]
41 SET @@PERSIST.sql_generate_invisible_primary_key = ON;
42 include/assert.inc [Reported value matches the one set (set ON in PERSIST scope)]
43 SET @@PERSIST.sql_generate_invisible_primary_key = TRUE;
44 include/assert.inc [Reported value matches the one set (set TRUE in PERSIST scope)]
45 SET @@PERSIST.sql_generate_invisible_primary_key = 1;
46 include/assert.inc [Reported value matches the one set (set 1 in PERSIST scope)]
47 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = 0;
48 include/assert.inc [Reported value matches the one set (set 0 in PERSIST_ONLY scope)]
49 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = DEFAULT;
50 include/assert.inc [Reported value matches the one set (set DEFAULT in PERSIST_ONLY scope)]
51 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = OFF;
52 include/assert.inc [Reported value matches the one set (set OFF in PERSIST_ONLY scope)]
53 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = FALSE;
54 include/assert.inc [Reported value matches the one set (set FALSE in PERSIST_ONLY scope)]
55 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = ON;
56 include/assert.inc [Reported value matches the one set (set ON in PERSIST_ONLY scope)]
57 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = TRUE;
58 include/assert.inc [Reported value matches the one set (set TRUE in PERSIST_ONLY scope)]
59 SET @@PERSIST_ONLY.sql_generate_invisible_primary_key = 1;
60 include/assert.inc [Reported value matches the one set (set 1 in PERSIST_ONLY scope)]
61 CREATE USER user1;
62 SET GLOBAL sql_generate_invisible_primary_key = ON;
63 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
64 SET SESSION sql_generate_invisible_primary_key = ON;
65 ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
66 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
67 SET GLOBAL sql_generate_invisible_primary_key=ON;
68 SET SESSION sql_generate_invisible_primary_key=ON;
69 REVOKE SYSTEM_VARIABLES_ADMIN ON *.* FROM user1@'%';
70 GRANT SESSION_VARIABLES_ADMIN ON *.* TO user1@'%';
71 SET SESSION sql_generate_invisible_primary_key = ON;
72 DROP USER user1;
73 RESET PERSIST;
74 SET SESSION sql_generate_invisible_primary_key = @saved_session_sql_generate_invisible_primary_key;
75 SET GLOBAL sql_generate_invisible_primary_key = @saved_global_sql_generate_invisible_primary_key;