Re: Add new LIST partition based on passed id in stored proc?

[Michael Zatkovetsky]

Thank you for taking a look. I tried your suggestion but getting Error Code: 1564. This partition function is not allowed

Here's my procedure:

DELIMITER $$
USE `mydb`$$

CREATE PROCEDURE `util_partioning_partition_new`(IN p_client_id INT)
BEGIN
DECLARE partition_name varchar(25);
SELECT CONCAT('p', p_client_id) INTO partition_name;

PREPARE stmt1 FROM 'ALTER TABLE test ADD PARTITION (PARTITION partition_name VALUES IN (?));';
SET @nid = p_client_id;

EXECUTE stmt1 USING @nid;
DEALLOCATE PREPARE stmt1;

END$$

DELIMITER ;
;

-------------------------
Error Code: 1564. This partition function is not allowed