db-migrate/node-db-migrate

Cannot migrate stored procedure

开放

#625 创建于 2019年5月24日

 (13 条评论) (2 个反应) (0 位负责人)JavaScript (367 个派生)batch import
Upstreamfeaturehelp wanted

仓库指标

星标
 (2,296 个星标)
PR 合并指标
 (30 天内没有已合并 PR)

描述

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.

贡献者指南