Describe the bug
The extension cannot run definitions of functions and procedures.
For example, with the simple function:
DELIMITER $$ CREATE FUNCTION test() returns INT deterministic BEGIN RETURN 1; END $$ DELIMITER ;
It returns the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
Expected behavior
No errors.
Screenshots
Desktop (please complete the following information):
SQLTools Version: v0.6.0
VS Code Version: 1.82.2
OS: Linux
Driver:
[x] MySQL/MariaDB
Database version: mysql Ver 14.14 Distrib 5.7.42, for Linux (x86_64) using EditLine wrapper
gjsjohnmurray
commented
8 months ago
Describe the bug The extension cannot run definitions of functions and procedures. For example, with the simple function:
DELIMITER $$ CREATE FUNCTION test() returns INT deterministic BEGIN RETURN 1; END $$ DELIMITER ;It returns the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$Expected behavior No errors.
Screenshots
Desktop (please complete the following information):
SQLTools Version: v0.6.0
VS Code Version: 1.82.2
OS: Linux
Driver:
Database version: mysql Ver 14.14 Distrib 5.7.42, for Linux (x86_64) using EditLine wrapper