Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/sys_vars/r/

Edit File: show_compatibility_56_basic.result

select @@global.show_compatibility_56;
@@global.show_compatibility_56
1
select @@session.show_compatibility_56;
ERROR HY000: Variable 'show_compatibility_56' is a GLOBAL variable
show global variables like 'show_compatibility_56';
Variable_name	Value
show_compatibility_56	ON
show session variables like 'show_compatibility_56';
Variable_name	Value
show_compatibility_56	ON
select * from information_schema.global_variables
where variable_name='show_compatibility_56';
VARIABLE_NAME	VARIABLE_VALUE
SHOW_COMPATIBILITY_56	ON
select * from information_schema.session_variables
where variable_name='show_compatibility_56';
VARIABLE_NAME	VARIABLE_VALUE
SHOW_COMPATIBILITY_56	ON
set global show_compatibility_56=1;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	ON
set global show_compatibility_56=0;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	OFF
set global show_compatibility_56=ON;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	ON
set global show_compatibility_56=OFF;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	OFF
set global show_compatibility_56=TRUE;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	ON
set global show_compatibility_56=FALSE;
show variables like "show_compatibility_56";
Variable_name	Value
show_compatibility_56	OFF
set global show_compatibility_56=999;
ERROR 42000: Variable 'show_compatibility_56' can't be set to the value of '999'
set session show_compatibility_56=1;
ERROR HY000: Variable 'show_compatibility_56' is a GLOBAL variable and should be set with SET GLOBAL