1SET @start_global_value = @@global.block_encryption_mode; 2SELECT @start_global_value; 3@start_global_value 4aes-128-ecb 5SET @start_session_value = @@session.block_encryption_mode; 6SELECT @start_session_value; 7@start_session_value 8aes-128-ecb 9'#--------------------FN_DYNVARS_002_01-------------------------#' 10SET @@global.block_encryption_mode = 'aes-192-ecb'; 11SET @@global.block_encryption_mode = DEFAULT; 12SELECT @@global.block_encryption_mode; 13@@global.block_encryption_mode 14aes-128-ecb 15SET @@session.block_encryption_mode = 'aes-192-ecb'; 16SET @@session.block_encryption_mode = DEFAULT; 17SELECT @@session.block_encryption_mode; 18@@session.block_encryption_mode 19aes-128-ecb 20'#--------------------FN_DYNVARS_002_02-------------------------#' 21SET @@global.block_encryption_mode = @start_global_value; 22SELECT @@global.block_encryption_mode = 'aes-128-ecb'; 23@@global.block_encryption_mode = 'aes-128-ecb' 241 25SET @@session.block_encryption_mode = @start_session_value; 26SELECT @@session.block_encryption_mode = 'aes-128-ecb'; 27@@session.block_encryption_mode = 'aes-128-ecb' 281 29'#--------------------FN_DYNVARS_002_03-------------------------#' 30SET @@global.block_encryption_mode = 'aes-128-ecb'; 31SELECT @@global.block_encryption_mode; 32@@global.block_encryption_mode 33aes-128-ecb 34SET @@global.block_encryption_mode = 'aes-256-ecb'; 35SELECT @@global.block_encryption_mode; 36@@global.block_encryption_mode 37aes-256-ecb 38SET @@global.block_encryption_mode = 'aes-256-cbc'; 39SELECT @@global.block_encryption_mode; 40@@global.block_encryption_mode 41aes-256-cbc 42'#--------------------FN_DYNVARS_002_04-------------------------#' 43SET @@session.block_encryption_mode = 'aes-128-ecb'; 44SELECT @@session.block_encryption_mode; 45@@session.block_encryption_mode 46aes-128-ecb 47SET @@session.block_encryption_mode = 'aes-256-ecb'; 48SELECT @@session.block_encryption_mode; 49@@session.block_encryption_mode 50aes-256-ecb 51SET @@session.block_encryption_mode = 'aes-256-cbc'; 52SELECT @@session.block_encryption_mode; 53@@session.block_encryption_mode 54aes-256-cbc 55'#------------------FN_DYNVARS_002_05-----------------------#' 56SET @@global.block_encryption_mode = 0; 57SELECT @@global.block_encryption_mode; 58@@global.block_encryption_mode 59aes-128-ecb 60SET @@global.block_encryption_mode = -1024; 61ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '-1024' 62SELECT @@global.block_encryption_mode; 63@@global.block_encryption_mode 64aes-128-ecb 65SET @@global.block_encryption_mode = 65536; 66ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '65536' 67SELECT @@global.block_encryption_mode; 68@@global.block_encryption_mode 69aes-128-ecb 70SET @@global.block_encryption_mode = 4294967295; 71ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '4294967295' 72SELECT @@global.block_encryption_mode; 73@@global.block_encryption_mode 74aes-128-ecb 75SET @@global.block_encryption_mode = 65535.4; 76ERROR 42000: Incorrect argument type to variable 'block_encryption_mode' 77SELECT @@global.block_encryption_mode; 78@@global.block_encryption_mode 79aes-128-ecb 80SET @@global.block_encryption_mode = ON; 81ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'ON' 82SELECT @@global.block_encryption_mode; 83@@global.block_encryption_mode 84aes-128-ecb 85SET @@global.block_encryption_mode = OFF; 86ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'OFF' 87SELECT @@global.block_encryption_mode; 88@@global.block_encryption_mode 89aes-128-ecb 90SET @@global.block_encryption_mode = test; 91ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'test' 92SELECT @@global.block_encryption_mode; 93@@global.block_encryption_mode 94aes-128-ecb 95SET @@global.block_encryption_mode = 'des-128-ecb'; 96ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'des-128-ecb' 97SELECT @@global.block_encryption_mode; 98@@global.block_encryption_mode 99aes-128-ecb 100SET @@session.block_encryption_mode = 0; 101SELECT @@session.block_encryption_mode; 102@@session.block_encryption_mode 103aes-128-ecb 104SET @@session.block_encryption_mode = -1024; 105ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '-1024' 106SELECT @@session.block_encryption_mode; 107@@session.block_encryption_mode 108aes-128-ecb 109SET @@session.block_encryption_mode = 65536; 110ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '65536' 111SELECT @@session.block_encryption_mode; 112@@session.block_encryption_mode 113aes-128-ecb 114SET @@session.block_encryption_mode = 4294967295; 115ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '4294967295' 116SELECT @@session.block_encryption_mode; 117@@session.block_encryption_mode 118aes-128-ecb 119SET @@session.block_encryption_mode = 65535.4; 120ERROR 42000: Incorrect argument type to variable 'block_encryption_mode' 121SELECT @@session.block_encryption_mode; 122@@session.block_encryption_mode 123aes-128-ecb 124SET @@session.block_encryption_mode = ON; 125ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'ON' 126SELECT @@session.block_encryption_mode; 127@@session.block_encryption_mode 128aes-128-ecb 129SET @@session.block_encryption_mode = OFF; 130ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'OFF' 131SELECT @@session.block_encryption_mode; 132@@session.block_encryption_mode 133aes-128-ecb 134SET @@session.block_encryption_mode = test; 135ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'test' 136SELECT @@session.block_encryption_mode; 137@@session.block_encryption_mode 138aes-128-ecb 139SET @@session.block_encryption_mode = 'des-128-ecb'; 140ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'des-128-ecb' 141SELECT @@session.block_encryption_mode; 142@@session.block_encryption_mode 143aes-128-ecb 144'#------------------FN_DYNVARS_002_06-----------------------#' 145SELECT @@global.block_encryption_mode = VARIABLE_VALUE 146FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 147WHERE VARIABLE_NAME='block_encryption_mode'; 148@@global.block_encryption_mode = VARIABLE_VALUE 1491 150'#------------------FN_DYNVARS_002_07-----------------------#' 151SELECT @@session.block_encryption_mode = VARIABLE_VALUE 152FROM INFORMATION_SCHEMA.SESSION_VARIABLES 153WHERE VARIABLE_NAME='block_encryption_mode'; 154@@session.block_encryption_mode = VARIABLE_VALUE 1551 156'#------------------FN_DYNVARS_002_08-----------------------#' 157SET @@global.block_encryption_mode = TRUE; 158SELECT @@global.block_encryption_mode; 159@@global.block_encryption_mode 160aes-192-ecb 161SET @@global.block_encryption_mode = FALSE; 162SELECT @@global.block_encryption_mode; 163@@global.block_encryption_mode 164aes-128-ecb 165'#---------------------FN_DYNVARS_001_09----------------------#' 166SET @@global.block_encryption_mode = 'aes-192-ecb'; 167SET @@session.block_encryption_mode = 'aes-256-cbc'; 168SELECT @@block_encryption_mode = @@global.block_encryption_mode; 169@@block_encryption_mode = @@global.block_encryption_mode 1700 171'#---------------------FN_DYNVARS_001_10----------------------#' 172SET @@block_encryption_mode = 'aes-192-cbc'; 173SELECT @@block_encryption_mode = @@local.block_encryption_mode; 174@@block_encryption_mode = @@local.block_encryption_mode 1751 176SELECT @@local.block_encryption_mode = @@session.block_encryption_mode; 177@@local.block_encryption_mode = @@session.block_encryption_mode 1781 179'#---------------------FN_DYNVARS_001_11----------------------#' 180SET block_encryption_mode = 'aes-128-cbc'; 181SELECT @@block_encryption_mode; 182@@block_encryption_mode 183aes-128-cbc 184SELECT local.block_encryption_mode; 185ERROR 42S02: Unknown table 'local' in field list 186SELECT session.block_encryption_mode; 187ERROR 42S02: Unknown table 'session' in field list 188SELECT block_encryption_mode = @@session.block_encryption_mode; 189ERROR 42S22: Unknown column 'block_encryption_mode' in 'field list' 190SET @@global.block_encryption_mode = @start_global_value; 191SELECT @@global.block_encryption_mode; 192@@global.block_encryption_mode 193aes-128-ecb 194SET @@session.block_encryption_mode = @start_session_value; 195SELECT @@session.block_encryption_mode; 196@@session.block_encryption_mode 197aes-128-ecb 198# 199# End of 5.7 tests 200# 201