SET @start_use_trim = @@global.innodb_use_trim; SELECT @start_use_trim; @start_use_trim 1 SELECT COUNT(@@GLOBAL.innodb_use_trim); COUNT(@@GLOBAL.innodb_use_trim) 1 1 Expected SET @@GLOBAL.innodb_use_trim=1; Warnings: Warning 131 Using innodb_use_trim is deprecated and the parameter will be removed in MariaDB 10.3. SELECT COUNT(@@GLOBAL.innodb_use_trim); COUNT(@@GLOBAL.innodb_use_trim) 1 1 Expected SELECT IF(@@GLOBAL.innodb_use_trim, 'ON', 'OFF') = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_use_trim'; IF(@@GLOBAL.innodb_use_trim, 'ON', 'OFF') = VARIABLE_VALUE 1 1 Expected SELECT COUNT(@@GLOBAL.innodb_use_trim); COUNT(@@GLOBAL.innodb_use_trim) 1 1 Expected SELECT COUNT(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_use_trim'; COUNT(VARIABLE_VALUE) 1 1 Expected SET @@global.innodb_use_trim = @start_use_trim; Warnings: Warning 131 Using innodb_use_trim is deprecated and the parameter will be removed in MariaDB 10.3. SELECT @@global.innodb_use_trim; @@global.innodb_use_trim 1