My stored procedure returns no error but actually does no work...

[phdphd]

Hi All,

 

I do not understand why the following stored procedure does not work.

DELIMITER $$

DROP PROCEDURE IF EXISTS `proc` $$

CREATE PROCEDURE `proc` ( )

BEGIN

   DECLARE result LONGTEXT;

   SET SESSION group_concat_max_len =4294967295;

   SET result = (SELECT GROUP_CONCAT( DISTINCT ids ORDER BY ids ASC SEPARATOR ',' ) FROM table1);

   INSERT INTO `table2 ` (`id`, `concat`) VALUES (NULL, result);

END $$

DELIMITER ;

When I run it, I get no error, but the insert instruction seems ignored. This insert instruction bears a variable, but even though I use a hard-coded value in it instead of the "result" variable, it still gets ignored (whereas it would work if executed alone).

 

Please note that when executed alone the SELECT GROUP_CONCAT instruction DOES return a concatenation.

 

Thanks for your help!

 

 

[phdphd]

Shame on me ! It does work ! Just forgot to test il with CALL...