Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
When we define stored procedures, functions, triggers or events, we have to use DELIMITER:
DELIMITER $$
|
CREATE PROCEDURE ... |
BEGIN
|
...
|
END $$ |
DELIMITER ;
|
This is the only way to write an SQL file that can be run by the mysql client.
But several database versioning tools break when they find DELIMITER. Some examples are Prisma and Postgrator.
In my tests, those tools just work if you remove DELIMITER and always use ";" as a delimiter. They seem to always understand where instructions end.
We need a way to write SQL files that work with any client. So please, either:
- make the CLI work without DELIMITER
- XOR make official connectors work with DELIMITER.