1SELECT COUNT(@@GLOBAL.version_suffix);
2COUNT(@@GLOBAL.version_suffix)
31
41 Expected
5SET @@GLOBAL.version_suffix=1;
6ERROR 42000: Incorrect argument type to variable 'version_suffix'
7Expected error 'Incorrect argument type to variable'
8SET @saved_version_suffix = @@global.version_suffix;
9SET GLOBAL version_suffix = DEFAULT;
10SET GLOBAL version_suffix = '';
11SET @version_base = @@global.version;
12SELECT @@global.version_suffix;
13@@global.version_suffix
14
15SET GLOBAL version_suffix = '-my_version';
16SELECT @@global.version_suffix;
17@@global.version_suffix
18-my_version
19include/assert.inc [Strings should be equal]
20SET GLOBAL version_suffix = '-my_version2';
21SELECT @@global.version_suffix;
22@@global.version_suffix
23-my_version2
24include/assert.inc [Strings should be equal]
25SET GLOBAL version_suffix = @saved_version_suffix;
26SELECT COUNT(@@GLOBAL.version_suffix);
27COUNT(@@GLOBAL.version_suffix)
281
291 Expected
30SELECT @@GLOBAL.version_suffix = VARIABLE_VALUE
31FROM performance_schema.global_variables
32WHERE VARIABLE_NAME='version_suffix';
33@@GLOBAL.version_suffix = VARIABLE_VALUE
341
351 Expected
36SELECT COUNT(@@GLOBAL.version_suffix);
37COUNT(@@GLOBAL.version_suffix)
381
391 Expected
40SELECT COUNT(VARIABLE_VALUE)
41FROM performance_schema.global_variables
42WHERE VARIABLE_NAME='version_suffix';
43COUNT(VARIABLE_VALUE)
441
451 Expected
46SELECT @@version_suffix = @@GLOBAL.version_suffix;
47@@version_suffix = @@GLOBAL.version_suffix
481
491 Expected
50SELECT COUNT(@@version_suffix);
51COUNT(@@version_suffix)
521
531 Expected
54SELECT COUNT(@@local.version_suffix);
55ERROR HY000: Variable 'version_suffix' is a GLOBAL variable
56Expected error 'Variable is a GLOBAL variable'
57SELECT COUNT(@@SESSION.version_suffix);
58ERROR HY000: Variable 'version_suffix' is a GLOBAL variable
59Expected error 'Variable is a GLOBAL variable'
60SELECT COUNT(@@GLOBAL.version_suffix);
61COUNT(@@GLOBAL.version_suffix)
621
631 Expected
64SELECT version_suffix = @@SESSION.version_suffix;
65ERROR 42S22: Unknown column 'version_suffix' in 'field list'
66Expected error 'Readonly variable'
67SET GLOBAL version_suffix = NULL;
68SHOW GLOBAL VARIABLES LIKE 'a';
69Variable_name	Value
70SELECT @@GLOBAL.version_suffix;
71@@GLOBAL.version_suffix
72NULL
73SELECT COUNT(@@GLOBAL.version_suffix);
74COUNT(@@GLOBAL.version_suffix)
750
760 Expected
77SET GLOBAL version_suffix = @saved_version_suffix;
78