Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create idempotent scripts #66

Open
Scantraxx123 opened this issue Nov 14, 2022 · 1 comment
Open

Create idempotent scripts #66

Scantraxx123 opened this issue Nov 14, 2022 · 1 comment

Comments

@Scantraxx123
Copy link

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
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant