CREATE OR REPLACE TRIGGER produces ER_TRG_DOES_NOT_EXIST

create table t1 (i int);

create table t2 (i int);

--echo # This works OK

create or replace trigger tr after insert on t1 for each row set @a=1;

--echo # This also works OK

create or replace trigger tr after insert on t1 for each row set @a=1;

--echo # This fails

create or replace trigger tr after insert on t2 for each row set @a=1;

drop table t1, t2;

MariaDB [test]> create or replace trigger tr after insert on t2 for each row set @a=1;

ERROR 1360 (HY000): Trigger does not exist