| 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 |
|