db-migrate / db-migrate/node-db-migrate
Cannot migrate stored procedure
- Dominant language
- JavaScript
- Stars
- 2.3k
- Forks
- 361
- PR merge metrics
- No merged PRs in 30d
Description
## I'm submitting a...
- [x] Bug report
- [ ] Feature request
- [ ] Question
## Current behavior
When created a stored procedure it's necessary to change the delimiter
e.g. DELIMITER $$
However, when using a SQL-file it returns ER_PARSE_ERROR:
## Expected behavior
Be able to change the delimiter, create the SP and return delimiter back to standard ;
## Minimal reproduction of the problem with instructions
DELIMITER //
CREATE PROCEDURE testProc()
BEGIN
SELECT 1;
END //
DELIMITER ;
## What is the motivation / use case for changing the behavior?
Cannot create or migrate stored procedures
## Environment
db-migrate version: 0.11.5
db-migrate-mysql with versions: 1.1.10
Additional information:
- Node version: 8.12.0
- Platform: Mac
Others:
---
Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/74601529-cannot-migrate-stored-procedure?utm_campaign=plugin&utm_content=tracker%2F73887&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F73887&utm_medium=issues&utm_source=github).
Contributor guide
Assessment
This issue has not been assessed yet.