Have been fighting with this for a a little , still cannot figure out what is wrong
The below is sql
-- liquibase formatted sql
-- changeset XXXX:YYYY-0.2.0
-- after insert
-- end-delimiter:$$
CREATE trigger tbl_timeseries_ai
AFTER INSERT
ON tbl_timeseries FOR EACH ROW
BEGIN
INSERT INTO tbl_timeseries_audit (id , action , name , description , datasource , ticker , field , frequency , currency , lag , deleted , version , updated_by ,updated_dt) values ( NEW.id , 'INSERT' , NEW.name , NEW.description , NEW.datasource , NEW.ticker , NEW.field , NEW.frequency , NEW.currency , NEW.lag , NEW.deleted , NEW.version , NEW.updated_by , New.update_dt);
END
$$
-- rollback drop trigger tbl_timeseries_ai;
-- after udpate
CREATE trigger tbl_timeseries_au
AFTER UPDATE
on tbl_timeseries FOR EACH ROW
BEGIN
INSERT INTO tbl_timeseries_audit (id , action , name , description , datasource , ticker , field , frequency , currency , lag , deleted , version , updated_by ,updated_dt) values ( NEW.id , 'UPDATE' , NEW.name , NEW.description , NEW.datasource , NEW.ticker , NEW.field , NEW.frequency , NEW.currency , NEW.lag , NEW.deleted , NEW.version , NEW.updated_by , New.update_dt);
END
$$
-- rollback drop trigger tbl_timeseries_au;
-- end-delimiter:;
Got the error “Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 14” ,
Line 14 is
INSERT INTO tbl_timeseries_audit (id , action , name , description , datasource , ticker , field , frequency , currency , lag , deleted , version , updated_by ,updated_dt) values ( NEW.id , 'INSERT' , NEW.name , NEW.description , NEW.datasource , NEW.ticker , NEW.field , NEW.frequency , NEW.currency , NEW.lag , NEW.deleted , NEW.version , NEW.updated_by , New.update_dt);
END ;
Could anyone please shed some light? Where is that ‘’ coming from?
Thanks