Laraue.EfCoreTriggers icon indicating copy to clipboard operation
Laraue.EfCoreTriggers copied to clipboard

Create idempotent scripts

Open Scantraxx123 opened this issue 2 years ago • 1 comments

I tried to create idempotent scripts with this library and I'm running into the problem that the script will be created properly, but when I want to execute the script this error message comes up:

Can't create a TRIGGER from within another stored routine

Is there a possiblity to enable this feature? I can imagine it could be tricky because it would be necessary to manipulate the generation of SQL there.

Scantraxx123 avatar Nov 14 '22 12:11 Scantraxx123

Also creating a non idempotent script results into the problem:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 7

This can be fixed if I add a the delimiter keyword properly inside the sql file. But it doesn't get generated automatically.

Scantraxx123 avatar Nov 14 '22 14:11 Scantraxx123