db-migrate/node-db-migrate

Cannot migrate stored procedure

オープン

#625 opened on 2019/05/24

 (13 件のコメント) (2 件のリアクション) (0 人の担当者)JavaScript (367 件のフォーク)batch import
Upstreamfeaturehelp wanted

Repository metrics

Stars
 (2,296 個のスター)
PR merge metrics
 (30d に merged 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.

コントリビューターガイド