Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_undo_log_truncate;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 '#---------------------BS_STVARS_028_01----------------------#'
6 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
7 COUNT(@@GLOBAL.innodb_undo_log_truncate)
8 1
9 1 Expected
10 '#---------------------BS_STVARS_028_02----------------------#'
11 SET @@global.innodb_undo_log_truncate = 0;
12 SELECT @@global.innodb_undo_log_truncate;
13 @@global.innodb_undo_log_truncate
14 0
15 SET @@global.innodb_undo_log_truncate ='On' ;
16 SELECT @@global.innodb_undo_log_truncate;
17 @@global.innodb_undo_log_truncate
18 1
19 SET @@global.innodb_undo_log_truncate ='Off' ;
20 SELECT @@global.innodb_undo_log_truncate;
21 @@global.innodb_undo_log_truncate
22 0
23 SET @@global.innodb_undo_log_truncate = 1;
24 SELECT @@global.innodb_undo_log_truncate;
25 @@global.innodb_undo_log_truncate
26 1
27 '#---------------------BS_STVARS_028_03----------------------#'
28 SELECT IF(@@GLOBAL.innodb_undo_log_truncate,'ON','OFF') = VARIABLE_VALUE
29 FROM performance_schema.global_variables
30 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
31 IF(@@GLOBAL.innodb_undo_log_truncate,'ON','OFF') = VARIABLE_VALUE
32 1
33 1 Expected
34 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
35 COUNT(@@GLOBAL.innodb_undo_log_truncate)
36 1
37 1 Expected
38 SELECT COUNT(VARIABLE_VALUE)
39 FROM performance_schema.global_variables
40 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
41 COUNT(VARIABLE_VALUE)
42 1
43 1 Expected
44 '#---------------------BS_STVARS_028_04----------------------#'
45 SELECT @@innodb_undo_log_truncate = @@GLOBAL.innodb_undo_log_truncate;
46 @@innodb_undo_log_truncate = @@GLOBAL.innodb_undo_log_truncate
47 1
48 1 Expected
49 '#---------------------BS_STVARS_028_05----------------------#'
50 SELECT COUNT(@@innodb_undo_log_truncate);
51 COUNT(@@innodb_undo_log_truncate)
52 1
53 1 Expected
54 SELECT COUNT(@@local.innodb_undo_log_truncate);
55 ERROR HY000: Variable 'innodb_undo_log_truncate' is a GLOBAL variable
56 Expected error 'Variable is a GLOBAL variable'
57 SELECT COUNT(@@SESSION.innodb_undo_log_truncate);
58 ERROR HY000: Variable 'innodb_undo_log_truncate' is a GLOBAL variable
59 Expected error 'Variable is a GLOBAL variable'
60 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
61 COUNT(@@GLOBAL.innodb_undo_log_truncate)
62 1
63 1 Expected
64 SELECT innodb_undo_log_truncate;
65 ERROR 42S22: Unknown column 'innodb_undo_log_truncate' in 'field list'
66 SET @@global.innodb_undo_log_truncate = @start_global_value;
67 SELECT @@global.innodb_undo_log_truncate;
68 @@global.innodb_undo_log_truncate
69 1