I finally got around to building an environment on the same version of MariaDB.
I used the following simplified versions of 2 stored procedures (as of course I
don't have the exact definitions of your tables) :
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE
`readShoplistIngredientsSort
Thanks for more info. Trying to find time to setup a test env with your exact
procedure.
>> CALL StoreDepartments(id_store);
I asked before, but I don't see you mentioning it anywhere. 'StoreDepartments'
is called from within 'readShoplistIngredientsSortedByStore'. Could you post a
definition