0

I have this procedure that works without any problem under MySQL:
fiddle
solution from here

I tried to add it to MariaDB 10.5 from within phpmyadmin - exactly like this, I just added DELIMITER ;; in the first line and END;; and DELIMITER ; at the end.

After that MySQL returned an empty result set and everything looks ok, but only when calling the procedure there are already errors like these

I'm guessing that the problem occurs with the separators that make up the two SELECTs, but my ideas to fix it so far have yielded nothing.

DeepSea
  • 305
  • 2
  • 15
  • MariaDB have no JSON_TABLE() function or something similar. – Akina Jun 28 '21 at 06:47
  • @Akina yea, actually, in MariaDB JSON_TABLE is available since version 10.6.0. Do you perhaps know how to improve this procedure so that it works on MariaDB without JSON? – DeepSea Jun 28 '21 at 07:59
  • Do the same using regular JSON and/or string functions. In MariaDB 10.5 you may use recursive CTE for iterative structure parsing and dynamic query text generation. – Akina Jun 28 '21 at 08:11

0 Answers0