Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.innodb_undo_tablespaces >= 2;
2 @@GLOBAL.innodb_undo_tablespaces >= 2
3 1
4 SET GLOBAL innodb_undo_tablespaces=2;
5 SELECT @@innodb_undo_tablespaces;
6 @@innodb_undo_tablespaces
7 2
8 # 2 Expected
9 SET GLOBAL innodb_undo_tablespaces=1;
10 Warnings:
11 Warning 1292 Truncated incorrect innodb_undo_tablespaces value: '1'
12 # Expected warning 'Truncated incorrect innodb_undo_tablespaces value'
13 SELECT @@innodb_undo_tablespaces;
14 @@innodb_undo_tablespaces
15 2
16 # 2 Expected
17 SET GLOBAL innodb_undo_tablespaces=0;
18 Warnings:
19 Warning 1292 Truncated incorrect innodb_undo_tablespaces value: '0'
20 # Expected warning 'Truncated incorrect innodb_undo_tablespaces value'
21 SELECT @@innodb_undo_tablespaces;
22 @@innodb_undo_tablespaces
23 2
24 # 2 Expected
25 SET GLOBAL innodb_undo_tablespaces=-1;
26 Warnings:
27 Warning 1292 Truncated incorrect innodb_undo_tablespaces value: '-1'
28 # Expected warning 'Truncated incorrect innodb_undo_tablespaces value'
29 SELECT @@innodb_undo_tablespaces;
30 @@innodb_undo_tablespaces
31 2
32 # 2 Expected
33 SET @@GLOBAL.innodb_undo_tablespaces=ORIGINAL_VALUE;;
34 SELECT COUNT(@@GLOBAL.innodb_undo_tablespaces);
35 COUNT(@@GLOBAL.innodb_undo_tablespaces)
36 1
37 # 1 Expected
38 DIFFERENCE
39 0
40 0 Expected
41 SELECT @@innodb_undo_tablespaces = @@GLOBAL.innodb_undo_tablespaces;
42 @@innodb_undo_tablespaces = @@GLOBAL.innodb_undo_tablespaces
43 1
44 # 1 Expected
45 SELECT COUNT(@@innodb_undo_tablespaces);
46 COUNT(@@innodb_undo_tablespaces)
47 1
48 # 1 Expected
49 SELECT COUNT(@@local.innodb_undo_tablespaces);
50 ERROR HY000: Variable 'innodb_undo_tablespaces' is a GLOBAL variable
51 # Expected error 'Variable is a GLOBAL variable'
52 SELECT COUNT(@@SESSION.innodb_undo_tablespaces);
53 ERROR HY000: Variable 'innodb_undo_tablespaces' is a GLOBAL variable
54 # Expected error 'Variable is a GLOBAL variable'
55 SELECT COUNT(@@GLOBAL.innodb_undo_tablespaces);
56 COUNT(@@GLOBAL.innodb_undo_tablespaces)
57 1
58 # 1 Expected
59 SELECT innodb_undo_tablespaces;
60 ERROR 42S22: Unknown column 'innodb_undo_tablespaces' in 'field list'
61 # Expected error 'Unknown column'