mysql-test/suite/sys_vars/t/old_basic.test
raw| 1 | # |
| 2 | # show the global and session values; |
| 3 | # |
| 4 | select @@global.old; |
| 5 | select @@session.old; |
| 6 | show global variables like 'old'; |
| 7 | show session variables like 'old'; |
| 8 | select * from information_schema.global_variables where variable_name='old'; |
| 9 | select * from information_schema.session_variables where variable_name='old'; |
| 10 | |
| 11 | set global old=1; |
| 12 | set session old=1; |
| 13 | select @@global.old; |
| 14 | select @@session.old; |
| 15 | set @@global.old=DEFAULT; |