db-migrate/node-db-migrate

Cannot migrate stored procedure

Open

#625 建立於 2019年5月24日

在 GitHub 查看
 (13 留言) (2 反應) (0 負責人)JavaScript (2,296 star) (367 fork)batch import
Upstreamfeaturehelp wanted

描述

I'm submitting a...

  • 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


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

貢獻者指南