[MDEV-6673] I_S.SESSION_VARIABLES shows global values - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.39, 10.0.13
Fix Version/s: 5.5.40, 10.0.14
Component/s: None
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';

Attachments

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2014-08-31 20:50

Updated:: 2014-08-31 23:34

Resolved:: 2014-08-31 23:34

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.