Jump to content

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


phdphd

Recommended Posts

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!

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.