mirror of
https://github.com/MariaDB/server.git
synced 2025-11-21 21:19:41 +01:00
32940e3442
In 12.1, remove the FIX_DISK_TMPTABLE_COSTS flag from @@new_mode. The new behavior is now always on.
71 lines
2.7 KiB
Text
71 lines
2.7 KiB
Text
SET @global_start_value = @@global.new_mode;
|
|
SELECT @global_start_value;
|
|
@global_start_value
|
|
|
|
SET @session_start_value = @@session.new_mode;
|
|
SELECT @session_start_value;
|
|
@session_start_value
|
|
|
|
SET @@global.new_mode = "FIX_DISK_TMPTABLE_COSTS";
|
|
Warnings:
|
|
Warning 4200 The setting 'new_mode=FIX_DISK_TMPTABLE_COSTS' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
SELECT @@global.new_mode;
|
|
@@global.new_mode
|
|
|
|
SELECT @@session.new_mode;
|
|
@@session.new_mode
|
|
|
|
SET @@global.new_mode = DEFAULT;
|
|
SELECT @@global.new_mode;
|
|
@@global.new_mode
|
|
|
|
SELECT @@session.new_mode;
|
|
@@session.new_mode
|
|
|
|
SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1";
|
|
Warnings:
|
|
Warning 4200 The setting 'new_mode=FIX_DISK_TMPTABLE_COSTS' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
Warning 4200 The setting 'new_mode=TEST_WARNING1' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2";
|
|
Warnings:
|
|
Warning 4200 The setting 'new_mode=FIX_DISK_TMPTABLE_COSTS' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
Warning 4200 The setting 'new_mode=TEST_WARNING1' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
Warning 4200 The setting 'new_mode=TEST_WARNING2' is ignored. It only exists for compatibility with old installations and will be removed in a future release
|
|
SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2,TEST_WARNING3";
|
|
ERROR 42000: Variable 'new_mode' can't be set to the value of 'TEST_WARNING3'
|
|
SET @@session.new_mode = "ALL";
|
|
select @@session.new_mode;
|
|
@@session.new_mode
|
|
|
|
SET @@global.new_mode = NULL;
|
|
ERROR 42000: Variable 'new_mode' can't be set to the value of 'NULL'
|
|
SET @@global.new_mode = '';
|
|
SELECT @@global.new_mode;
|
|
@@global.new_mode
|
|
|
|
SET @@global.new_mode = ' ';
|
|
SELECT @@global.new_mode;
|
|
@@global.new_mode
|
|
|
|
SET @@session.new_mode = NULL;
|
|
ERROR 42000: Variable 'new_mode' can't be set to the value of 'NULL'
|
|
SET @@session.new_mode = '';
|
|
SELECT @@session.new_mode;
|
|
@@session.new_mode
|
|
|
|
SET @@session.new_mode = ' ';
|
|
SELECT @@session.new_mode;
|
|
@@session.new_mode
|
|
|
|
SET @@global.new_mode = OFF;
|
|
ERROR 42000: Variable 'new_mode' can't be set to the value of 'OFF'
|
|
SET @@session.new_mode = OFF;
|
|
ERROR 42000: Variable 'new_mode' can't be set to the value of 'OFF'
|
|
SET @@global.new_mode = @global_start_value;
|
|
SELECT @@global.new_mode;
|
|
@@global.new_mode
|
|
|
|
SET @@session.new_mode = @session_start_value;
|
|
SELECT @@session.new_mode;
|
|
@@session.new_mode
|
|
|