[MDEV-6673] I_S.SESSION_VARIABLES shows global values Created: 2014-08-31  Updated: 2014-08-31  Resolved: 2014-08-31

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.39, 10.0.13
Fix Version/s: 5.5.40, 10.0.14

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

I_S.SESSION_VARIABLES shows global data, for example, if the previous statement is SET GLOBAL or SHOW GLOBAL.

set session sql_mode=ansi_quotes;
 
select * from information_schema.session_variables where variable_name='sql_mode';
 
show global status like 'foobar';
 
select * from information_schema.session_variables where variable_name='sql_mode';


Generated at Thu Feb 08 07:13:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.