1SET @start_global_value = @@global.innodb_strict_mode; 2SELECT @start_global_value; 3@start_global_value 41 5Valid values are 'ON' and 'OFF' 6select @@global.innodb_strict_mode in (0, 1); 7@@global.innodb_strict_mode in (0, 1) 81 9select @@global.innodb_strict_mode; 10@@global.innodb_strict_mode 111 12select @@session.innodb_strict_mode in (0, 1); 13@@session.innodb_strict_mode in (0, 1) 141 15select @@session.innodb_strict_mode; 16@@session.innodb_strict_mode 171 18show global variables like 'innodb_strict_mode'; 19Variable_name Value 20innodb_strict_mode ON 21show session variables like 'innodb_strict_mode'; 22Variable_name Value 23innodb_strict_mode ON 24select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 25VARIABLE_NAME VARIABLE_VALUE 26INNODB_STRICT_MODE ON 27select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 28VARIABLE_NAME VARIABLE_VALUE 29INNODB_STRICT_MODE ON 30set global innodb_strict_mode='OFF'; 31set session innodb_strict_mode='OFF'; 32select @@global.innodb_strict_mode; 33@@global.innodb_strict_mode 340 35select @@session.innodb_strict_mode; 36@@session.innodb_strict_mode 370 38select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 39VARIABLE_NAME VARIABLE_VALUE 40INNODB_STRICT_MODE OFF 41select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 42VARIABLE_NAME VARIABLE_VALUE 43INNODB_STRICT_MODE OFF 44set @@global.innodb_strict_mode=1; 45set @@session.innodb_strict_mode=1; 46select @@global.innodb_strict_mode; 47@@global.innodb_strict_mode 481 49select @@session.innodb_strict_mode; 50@@session.innodb_strict_mode 511 52select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 53VARIABLE_NAME VARIABLE_VALUE 54INNODB_STRICT_MODE ON 55select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 56VARIABLE_NAME VARIABLE_VALUE 57INNODB_STRICT_MODE ON 58set global innodb_strict_mode=0; 59set session innodb_strict_mode=0; 60select @@global.innodb_strict_mode; 61@@global.innodb_strict_mode 620 63select @@session.innodb_strict_mode; 64@@session.innodb_strict_mode 650 66select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 67VARIABLE_NAME VARIABLE_VALUE 68INNODB_STRICT_MODE OFF 69select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 70VARIABLE_NAME VARIABLE_VALUE 71INNODB_STRICT_MODE OFF 72set @@global.innodb_strict_mode='ON'; 73set @@session.innodb_strict_mode='ON'; 74select @@global.innodb_strict_mode; 75@@global.innodb_strict_mode 761 77select @@session.innodb_strict_mode; 78@@session.innodb_strict_mode 791 80select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 81VARIABLE_NAME VARIABLE_VALUE 82INNODB_STRICT_MODE ON 83select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 84VARIABLE_NAME VARIABLE_VALUE 85INNODB_STRICT_MODE ON 86set global innodb_strict_mode=1.1; 87ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode' 88set session innodb_strict_mode=1.1; 89ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode' 90set global innodb_strict_mode=1e1; 91ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode' 92set session innodb_strict_mode=1e1; 93ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode' 94set global innodb_strict_mode=2; 95ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '2' 96set session innodb_strict_mode=2; 97ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '2' 98set global innodb_strict_mode='AUTO'; 99ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of 'AUTO' 100set session innodb_strict_mode='AUTO'; 101ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of 'AUTO' 102set global innodb_strict_mode=-3; 103ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '-3' 104set session innodb_strict_mode=-7; 105ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '-7' 106select @@global.innodb_strict_mode; 107@@global.innodb_strict_mode 1081 109select @@session.innodb_strict_mode; 110@@session.innodb_strict_mode 1111 112select * from information_schema.global_variables where variable_name='innodb_strict_mode'; 113VARIABLE_NAME VARIABLE_VALUE 114INNODB_STRICT_MODE ON 115select * from information_schema.session_variables where variable_name='innodb_strict_mode'; 116VARIABLE_NAME VARIABLE_VALUE 117INNODB_STRICT_MODE ON 118SET @@global.innodb_strict_mode = @start_global_value; 119SELECT @@global.innodb_strict_mode; 120@@global.innodb_strict_mode 1211 122