diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/old_alter_table_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/old_alter_table_basic.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/old_alter_table_basic.result b/mysql-test/suite/sys_vars/r/old_alter_table_basic.result index 8b668340d1a..3cc7fff79ba 100644 --- a/mysql-test/suite/sys_vars/r/old_alter_table_basic.result +++ b/mysql-test/suite/sys_vars/r/old_alter_table_basic.result @@ -21,7 +21,11 @@ select * from information_schema.session_variables where variable_name='old_alte VARIABLE_NAME VARIABLE_VALUE OLD_ALTER_TABLE DEFAULT set global old_alter_table=1; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead set session old_alter_table=1; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead select @@global.old_alter_table; @@global.old_alter_table COPY @@ -41,7 +45,11 @@ select * from information_schema.session_variables where variable_name='old_alte VARIABLE_NAME VARIABLE_VALUE OLD_ALTER_TABLE COPY set global old_alter_table=2; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead set session old_alter_table=2; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead select @@global.old_alter_table; @@global.old_alter_table INPLACE @@ -61,7 +69,11 @@ select * from information_schema.session_variables where variable_name='old_alte VARIABLE_NAME VARIABLE_VALUE OLD_ALTER_TABLE INPLACE set global old_alter_table=3; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead set session old_alter_table=3; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead select @@global.old_alter_table; @@global.old_alter_table NOCOPY @@ -81,7 +93,11 @@ select * from information_schema.session_variables where variable_name='old_alte VARIABLE_NAME VARIABLE_VALUE OLD_ALTER_TABLE NOCOPY set global old_alter_table=4; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead set session old_alter_table=4; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead select @@global.old_alter_table; @@global.old_alter_table INSTANT @@ -107,6 +123,8 @@ ERROR 42000: Incorrect argument type to variable 'old_alter_table' set global old_alter_table="foo"; ERROR 42000: Variable 'old_alter_table' can't be set to the value of 'foo' SET @@global.old_alter_table = @start_global_value; +Warnings: +Warning 1287 '@@old_alter_table' is deprecated and will be removed in a future release. Please use '@@alter_algorithm' instead SELECT @@global.old_alter_table; @@global.old_alter_table DEFAULT |