Debian Codegraph @

mysql-test/suite/perfschema/r/user_var_func.result

raw
1 set @v1a="Hello";
2 set @v2a="World";
3 set @v3a=65;
4 set @v4a=NULL;
5 select @v1a, @v2a, @v3a, @v4a, @v_unknown;
6 @v1a @v2a @v3a @v4a @v_unknown
7 Hello World 65 NULL NULL
8 select VARIABLE_NAME, VARIABLE_VALUE
9 from performance_schema.user_variables_by_thread
10 inner join performance_schema.threads
11 on user_variables_by_thread.thread_id=threads.thread_id
12 where threads.processlist_id=connection_id()
13 order by VARIABLE_NAME;
14 VARIABLE_NAME VARIABLE_VALUE
15 v1a Hello
16 v2a World
17 v3a 65
18 v4a NULL
19 connect con1, localhost, root,,;
20 set @v1b="Salut";
21 set @v2b="La compagnie";
22 set @v3b=12;
23 set @v4b=NULL;
24 select @v1b, @v2b, @v3b, @v4b, @v_unknown;
25 @v1b @v2b @v3b @v4b @v_unknown
26 Salut La compagnie 12 NULL NULL
27 select VARIABLE_NAME, VARIABLE_VALUE
28 from performance_schema.user_variables_by_thread
29 inner join performance_schema.threads
30 on user_variables_by_thread.thread_id=threads.thread_id
31 where threads.processlist_id in ($default_id, connection_id())
32 order by VARIABLE_NAME;
33 VARIABLE_NAME VARIABLE_VALUE
34 v1a Hello
35 v1b Salut
36 v2a World
37 v2b La compagnie
38 v3a 65
39 v3b 12
40 v4a NULL
41 v4b NULL
42 connection default;
43 disconnect con1;
44 select VARIABLE_NAME, VARIABLE_VALUE
45 from performance_schema.user_variables_by_thread
46 order by VARIABLE_NAME;
47 VARIABLE_NAME VARIABLE_VALUE
48 v1a Hello
49 v2a World
50 v3a 65
51 v4a NULL
52 set @blob_under_16_bits=repeat("a", 65000);
53 set @blob_under_24_bits=repeat("a", 1000000);
54 select length(@blob_under_16_bits);
55 length(@blob_under_16_bits)
56 65000
57 select length(@blob_under_24_bits);
58 length(@blob_under_24_bits)
59 1000000
60 select variable_name, length(variable_value)
61 from performance_schema.user_variables_by_thread
62 where VARIABLE_NAME like "blob%"
63 order by VARIABLE_NAME;
64 variable_name length(variable_value)
65 blob_under_16_bits 65000
66 blob_under_24_bits 1000000
67 set @a=10;
68 CREATE procedure test_user_val
69 (IN input INT,OUT output INT)
70 BEGIN
71 SELECT input + input
72 INTO output;
73 END|
74 CALL test_user_val(@a , @total);
75 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
76 where variable_name in ('a','total') order by VARIABLE_NAME;
77 VARIABLE_NAME VARIABLE_VALUE
78 a 10
79 total 20
80 create table t1 (c1 int);
81 CREATE TRIGGER test_uvar_trigger
82 AFTER INSERT ON t1
83 FOR EACH ROW BEGIN
84 set @a=@a+@a;
85 END|
86 insert into t1 values(1);
87 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
88 where variable_name ='a' order by VARIABLE_NAME;
89 VARIABLE_NAME VARIABLE_VALUE
90 a 20
91 insert into t1 values(1);
92 select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread
93 where variable_name ='a' order by VARIABLE_NAME;
94 VARIABLE_NAME VARIABLE_VALUE
95 a 40
96 drop table t1;
97 drop procedure test_user_val;