Undeclared variable using SELECT ... INTO in dynamic SQL

[Carsten Klotz]

Hi,

I have the following procedure:

drop procedure if exists test;

delimiter $$

create procedure test ()
begin
	declare table_conflicts int default 0;
	set @sql = concat('select count(*) into table_conflicts from user where id = 1;');
	prepare stmt from @sql;
	execute stmt;
end;

$$

delimiter ;
    
CALL test();

The call statement brings "Undeclared variable: table_conflicts". SELECT ... INTO is not supported for functions but for procedures, so I'm a little bit confused about this error. Anybody can help me ?

Thanx in advance !