maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx