db-migrate / db-migrate/node-db-migrate

Cannot migrate stored procedure

Open
#625 13 comments 2 reactions 0 assignees View on GitHub
feature help wanted Upstream
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.