Syntax error near RECURSIVE when trying to create a procedure in mysql

Question

I am trying to implement a procedure in mysql using datagrip but I am still getting this errror.

[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RECURSIVE descendants AS ( SELECT e.activity, CAST(e.activity AS CHAR(500)) AS' at line 3

I am running on windows

mysql Ver 8.0.15 for Win64 on x86_64 (MySQL Community Server - GPL) Server version: 5.5.5-10.1.37-MariaDB mariadb.org binary distribution

CREATE DEFINER=`root`@`localhost` PROCEDURE `findPaths`()
BEGIN
WITH RECURSIVE descendants AS
(
SELECT e.activity, CAST(e.activity AS CHAR(500)) AS path, n.cost as total_cost
FROM edges e JOIN nodes n
ON e.activity=n.code
WHERE e.activity='A'
UNION ALL
SELECT e.activity, CONCAT(d.path, ',', e.activity), d.total_cost+(SELECT cost FROM nodes WHERE code=e.activity)
FROM descendants d, edges e
WHERE e.parent=d.activity
)
SELECT * FROM descendants WHERE activity='M' OR activity='N' ORDER BY total_cost;

END

I want the procedure to be created and accessible in order to be run

danblack · Accepted Answer · 2019-04-17 06:00:08Z

3

Recursive CTE where added in MariaDB-10.2

From your version string you have MariaDB-10.1.37

answered Apr 17, 2019 at 6:00

danblack

14.9k2 gold badges27 silver badges49 bronze badges

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

1 Comment

danblack Over a year ago

downloads.mariadb.org has installers I assume. Not sure how it was originally installed.

Collectives™ on Stack Overflow

Syntax error near RECURSIVE when trying to create a procedure in mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related