Debian Codegraph @

mysql-test/suite/sys_vars/t/show_create_table_verbosity_basic.test

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