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