maria-discuss team mailing list archive

[Ian Gilfillan <ian@xxxxxxxxxxx>]

On 30/11/2016 15:13, Federico Razzoli wrote:
> This always shows the global value:
> SHOW VARIABLES LIKE ...
>
> This always shows the current session value:
> SHOW SESSION VARIABLES LIKE ...

This is not correct. SHOW VARIABLES shows the session value:

SET GLOBAL wait_timeout=601;
SET SESSION wait_timeout=599;

SHOW SESSION VARIABLES LIKE 'wait_%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 599   |
+---------------+-------+

SHOW GLOBAL VARIABLES LIKE 'wait_%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 601   |
+---------------+-------+

SHOW VARIABLES LIKE 'wait_%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 599   |
+---------------+-------+