Debian Codegraph @

mysql-test/suite/sys_vars/r/pseudo_thread_id_basic.result

raw
1 select @@global.pseudo_thread_id;
2 ERROR HY000: Variable 'pseudo_thread_id' is a SESSION variable
3 should be empty
4 show global variables like 'pseudo_thread_id';
5 Variable_name Value
6 show session variables like 'pseudo_thread_id';
7 Variable_name Value
8 pseudo_thread_id #
9 should be empty
10 select * from information_schema.global_variables where variable_name='pseudo_thread_id';
11 VARIABLE_NAME VARIABLE_VALUE
12 select @@session.pseudo_thread_id = variable_value from information_schema.session_variables where variable_name='pseudo_thread_id';
13 @@session.pseudo_thread_id = variable_value
14 1
15 set session pseudo_thread_id=42;
16 select @@session.pseudo_thread_id;
17 @@session.pseudo_thread_id
18 42
19 select * from information_schema.global_variables where variable_name='pseudo_thread_id';
20 VARIABLE_NAME VARIABLE_VALUE
21 select variable_value from information_schema.session_variables where variable_name='pseudo_thread_id';
22 variable_value
23 42
24 set global pseudo_thread_id=1;
25 ERROR HY000: Variable 'pseudo_thread_id' is a SESSION variable and can't be used with SET GLOBAL
26 set session pseudo_thread_id=1.1;
27 ERROR 42000: Incorrect argument type to variable 'pseudo_thread_id'
28 set session pseudo_thread_id=1e1;
29 ERROR 42000: Incorrect argument type to variable 'pseudo_thread_id'
30 set session pseudo_thread_id="foo";
31 ERROR 42000: Incorrect argument type to variable 'pseudo_thread_id'