Re: [Maria-developers] ddec45aa50e: MDEV-16932: ASAN heap-use-after-free in my_charlen_utf8 / my_well_formed_char_length_utf8 on 2nd execution of SP with ALTER trying to add bad CHECK

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