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
Error when creating trigger #1172
Comments
@DanielBailey-web the 0.6.0 version of the MySQL driver which it looks like you're using was published only yesterday. Have you previously been able to run this kind of SQL code against your MySQL database using an earlier version of the driver? Or are you using SQLTools this way for the first time? A potential way to determine if the problem is specific to 0.6.0 is to use the gearwheel menu alongside the MySQL driver extension in VS Code's Extensions view, then choose "Install Another Version...", then pick 0.5.1. You'll be prompted to reload VS Code. Then you can test the same statements to see if it's an old problem or a new one. |
I had tried previously and it did not work with 0.5.1. I had commented on the PR #1140 (albeit on a different GitHub account @VulcanTech-io) for 0.5.2 asking if that would fix it. But no one got back to me on it 😬 |
The same issue also exists for SQLite, which uses the same/similar syntax for trigger definitions: https://www.sqlite.org/lang_createtrigger.html. Every trigger definition contains embedded semicolons. Another SQL related project ran into the same issues some years ago, if I understand this issue and the related PR correctly. |
@gjsjohnmurray is there any movement on this? This is quite literally a feature I would use daily. |
@DanielBailey-web I am not aware of anyone actively working on this at the moment. |
Describe the bug
I get the following error when running the code below:
To Reproduce
I assume the problem would work with any trigger that you try to create.
Expected behavior
Trigger should be created
Code
Desktop (please complete the following information):
The text was updated successfully, but these errors were encountered: