Debian Codegraph @

mysql-test/suite/perfschema/t/user_var_func.test

raw
1
2 --source include/not_embedded.inc
3 --source include/have_perfschema.inc
4
5 let $default_id= `select connection_id()`;
6
7 set @v1a="Hello";
8 set @v2a="World";
9 set @v3a=65;
10 set @v4a=NULL;
11
12 select @v1a, @v2a, @v3a, @v4a, @v_unknown;
13
14 select VARIABLE_NAME, VARIABLE_VALUE
15 from performance_schema.user_variables_by_thread
16 inner join performance_schema.threads
17 on user_variables_by_thread.thread_id=threads.thread_id
18 where threads.processlist_id=connection_id()
19 order by VARIABLE_NAME;
20
21 connect(con1, localhost, root,,);
22
23 set @v1b="Salut";
24 set @v2b="La compagnie";
25 set @v3b=12;
26 set @v4b=NULL;
27
28 select @v1b, @v2b, @v3b, @v4b, @v_unknown;
29
30 evalp select VARIABLE_NAME, VARIABLE_VALUE
31 from performance_schema.user_variables_by_thread
32 inner join performance_schema.threads
33 on user_variables_by_thread.thread_id=threads.thread_id
34 where threads.processlist_id in ($default_id, connection_id())
35 order by VARIABLE_NAME;
36
37 --connection default
38 --disconnect con1
39
40 # Wait till all disconnects are completed
41 let $count_sessions= 1;
42 --source include/wait_until_count_sessions.inc
43
44 select VARIABLE_NAME, VARIABLE_VALUE
45 from performance_schema.user_variables_by_thread
46 order by VARIABLE_NAME;
47
48 # Make sure large values are not truncated
49 set @blob_under_16_bits=repeat("a", 65000);
50 set @blob_under_24_bits=repeat("a", 1000000);
51
52 # Not testable because of limitation on max_allowed_packet
53 # set @blob_under_32_bits=repeat("a", 20000000);
54
55 select length(@blob_under_16_bits);
56 select length(@blob_under_24_bits);
57 # select length(@blob_under_32_bits);
58
59 select variable_name, length(variable_value)
60 from performance_schema.user_variables_by_thread
61 where VARIABLE_NAME like "blob%"
62 order by VARIABLE_NAME;
63
64
65 # Check the behaviour with procedures if the values passed inside procedures gets reflected in the table performance_schema.user_variables_by_thread.
66
67 set @a=10;
68
69 DELIMITER |;
70 CREATE procedure test_user_val
71 (IN input INT,OUT output INT)
72 BEGIN
73 SELECT input + input
74 INTO output;
75 END|
76 DELIMITER ;|
77
78 CALL test_user_val(@a , @total);
79 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
80 where variable_name in ('a','total') order by VARIABLE_NAME;
81
82
83 # Checking behaviour around triggers if the values in performance_schema.user_variables_by_thread are updated from within trigger
84
85 create table t1 (c1 int);
86
87 DELIMITER |;
88 CREATE TRIGGER test_uvar_trigger
89 AFTER INSERT ON t1
90 FOR EACH ROW BEGIN
91 set @a=@a+@a;
92 END|
93 DELIMITER ;|
94
95 insert into t1 values(1);
96 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
97 where variable_name ='a' order by VARIABLE_NAME;
98
99 insert into t1 values(1);
100 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
101 where variable_name ='a' order by VARIABLE_NAME;
102
103 drop table t1;
104 drop procedure test_user_val;
105 #drop TRIGGER test_uvar_trigger;
106
107
108
109