Debian Codegraph @

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

raw
1 SELECT @@session.show_create_table_verbosity;
2 @@session.show_create_table_verbosity
3 0
4 SHOW SESSION VARIABLES LIKE 'show_create_table_verbosity';
5 Variable_name Value
6 show_create_table_verbosity OFF
7 SELECT * FROM performance_schema.session_variables WHERE variable_name='show_create_table_verbosity';
8 VARIABLE_NAME VARIABLE_VALUE
9 show_create_table_verbosity OFF
10 #Also can be set as a global variable.
11 SELECT @@global.show_create_table_verbosity;
12 @@global.show_create_table_verbosity
13 0
14 SHOW GLOBAL VARIABLES LIKE 'show_create_table_verbosity';
15 Variable_name Value
16 show_create_table_verbosity OFF
17 SELECT * FROM performance_schema.global_variables WHERE variable_name='show_create_table_verbosity';
18 VARIABLE_NAME VARIABLE_VALUE
19 show_create_table_verbosity OFF
20 #Test setting the variable to various values.
21 #Boolean values.
22 SET SESSION show_create_table_verbosity= ON;
23 SELECT @@session.show_create_table_verbosity;
24 @@session.show_create_table_verbosity
25 1
26 SET SESSION show_create_table_verbosity= OFF;
27 SELECT @@session.show_create_table_verbosity;
28 @@session.show_create_table_verbosity
29 0
30 SET SESSION show_create_table_verbosity= 1;
31 SELECT @@session.show_create_table_verbosity;
32 @@session.show_create_table_verbosity
33 1
34 SET SESSION show_create_table_verbosity= 0;
35 SELECT @@session.show_create_table_verbosity;
36 @@session.show_create_table_verbosity
37 0
38 #Test for DEFAULT value.
39 SET SESSION show_create_table_verbosity= DEFAULT;
40 SELECT @@session.show_create_table_verbosity;
41 @@session.show_create_table_verbosity
42 0
43 #Test for invalid value.
44 SET SESSION show_create_table_verbosity= 2;
45 ERROR 42000: Variable 'show_create_table_verbosity' can't be set to the value of '2'
46 #Test for setting the session variable
47 #using different syntax.
48 SET show_create_table_verbosity= 1;
49 #Fetches the current session value for the variable.
50 SELECT @@show_create_table_verbosity;
51 @@show_create_table_verbosity
52 1
53 #cleanup
54 SET SESSION show_create_table_verbosity= DEFAULT;
55 #Test setting the global value of the variable.
56 #Boolean values.
57 SET GLOBAL show_create_table_verbosity= ON;
58 SELECT @@global.show_create_table_verbosity;
59 @@global.show_create_table_verbosity
60 1
61 SET GLOBAL show_create_table_verbosity= OFF;
62 SELECT @@global.show_create_table_verbosity;
63 @@global.show_create_table_verbosity
64 0
65 SET GLOBAL show_create_table_verbosity= 1;
66 SELECT @@global.show_create_table_verbosity;
67 @@global.show_create_table_verbosity
68 1
69 SET GLOBAL show_create_table_verbosity= 0;
70 SELECT @@session.show_create_table_verbosity;
71 @@session.show_create_table_verbosity
72 0
73 #Test for DEFAULT value.
74 SET GLOBAL show_create_table_verbosity= DEFAULT;
75 SELECT @@global.show_create_table_verbosity;
76 @@global.show_create_table_verbosity
77 0
78 #Test for invalid value.
79 SET GLOBAL show_create_table_verbosity= 2;
80 ERROR 42000: Variable 'show_create_table_verbosity' can't be set to the value of '2'