Hi, Oleksandr! On May 20, Oleksandr Byelkin wrote:

Alter table will trigger recompilation of the SP (as I remember all SPs)

I've run this test, it complains about duplicate constraint name.

...

What about this:

CREATE TABLE t1 (a INT); CREATE PROCEDURE sp() ALTER TABLE t1 ADD CONSTRAINT CHECK (b > 0); --error ER_BAD_FIELD_ERROR CALL sp; alter table t1 add column b int, add constraint check (b < 10); CALL sp;

? second CALL will not regenerate the name of the constraint.

Regards, Sergei Chief Architect MariaDB and security@mariadb.org