Debian Codegraph @

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

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