Debian Codegraph @

mysql-test/suite/sys_vars/r/old_basic.result

raw
1 select @@global.old;
2 @@global.old
3 0
4 select @@session.old;
5 @@session.old
6 0
7 show global variables like 'old';
8 Variable_name Value
9 old OFF
10 show session variables like 'old';
11 Variable_name Value
12 old OFF
13 select * from information_schema.global_variables where variable_name='old';
14 VARIABLE_NAME VARIABLE_VALUE
15 OLD OFF
16 select * from information_schema.session_variables where variable_name='old';
17 VARIABLE_NAME VARIABLE_VALUE
18 OLD OFF
19 set global old=1;
20 Warnings:
21 Warning 1287 '@@old' is deprecated and will be removed in a future release. Please use '@@old_mode' instead
22 set session old=1;
23 Warnings:
24 Warning 1287 '@@old' is deprecated and will be removed in a future release. Please use '@@old_mode' instead
25 select @@global.old;
26 @@global.old
27 1
28 select @@session.old;
29 @@session.old
30 1
31 set @@global.old=DEFAULT;
32 Warnings:
33 Warning 1287 '@@old' is deprecated and will be removed in a future release. Please use '@@old_mode' instead