From 6389fd3c7974a017e19142d280fb309304de5621 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Sun, 31 Aug 2014 19:55:11 +0200 Subject: MDEV-6673 I_S.SESSION_VARIABLES shows global values only look at lex->option_type if it's a SHOW command, not a SELECT --- mysql-test/t/variables.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/variables.test') diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index b1288b6e24d..28f4344bd38 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -1553,4 +1553,12 @@ set session rand_seed1=DEFAULT; --error ER_BAD_FIELD_ERROR set autocommit = values(v); +# +# MDEV-6673 I_S.SESSION_VARIABLES shows global values +# +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'; + --echo End of 5.5 tests -- cgit v1.2.1