Issue with variable initialization : Into does not reset variable if 0 records are returned

[Phil Siyam]

MySql version : 8.0.28
table1
column1
111
222


set @aa = 'ABC';

select @aa aa
Returns ABC

select column1 into @aa from table1 where column1 = 111

select @aa aa
Returns 111

select column1 into @aa from table1 where column1 = 777

select @aa aa
Returns 111 -- expected output should blank or null

Works Ok with set command

set @aa = (select column1 into @aa from table1 where column1 = 777)

select @aa aa
Returns Null -- expected output should blank or null