Flyway produces MySQL syntax error while raw script does not

Question

For the following MySql script Flyway produces a MySQL syntax error while running the script directly in something like Navicat works fine. Can anyone tell me why that is?

CREATE PROCEDURE RegressionTest_Genealogy (OUT Success TINYINT)
BEGIN  
    DECLARE MetricVerification TINYINT;
    SET Success = 0;

    SELECT COUNT(MERTRICID) INTO MetricVerification FROM metrics_temp WHERE lft = 0 OR rgt = 0;

    IF MetricVerification = 0 THEN
        SET Success = 1;
    END IF;
END

Don't forget to share your error.

Sabyasachi Mishra
– Sabyasachi Mishra

2015-08-04 17:45:31 +00:00
Commented Aug 4, 2015 at 17:45 — Sabyasachi Mishra
– Sabyasachi Mishra, Commented Aug 4, 2015 at 17:45

Axel Fontaine · Accepted Answer · 2015-08-12 10:02:58Z

2

You probably need to issue a delimiter change first to make this work, as per default the delimiter is ; which is contained in your procedure body.

answered Aug 12, 2015 at 10:02

Axel Fontaine

35.4k19 gold badges110 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DBHash.com · Accepted Answer · 2015-08-12 10:07:37Z

2

Try this

DELIMITER //
CREATE PROCEDURE RegressionTest_Genealogy (OUT Success TINYINT)
BEGIN  
DECLARE MetricVerification TINYINT;

SET Success = 0;

SELECT COUNT(MERTRICID) INTO MetricVerification FROM metrics_temp WHERE lft = 0 OR rgt = 0;

IF MetricVerification = 0 THEN
    SET Success = 1;
END IF;
END //
DELIMITER ;

answered Aug 12, 2015 at 10:07

DBHash.com

5842 silver badges7 bronze badges

Collectives™ on Stack Overflow

Flyway produces MySQL syntax error while raw script does not

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related