Lack of DELIMITER support in Azure Data Studio with MySQL extension

[matuszykw]

Type: Bug

Azure Data Studio with the MySQL extension does not support the DELIMITER command, which is necessary for creating stored procedures with multiple statements in MySQL. Without this feature, it is impossible to define complex procedures directly within Azure Data Studio, as the tool interprets the first ; as the end of the procedure definition.

Steps to Reproduce:
Open Azure Data Studio with the MySQL extension installed.
Connect to a MySQL database.
Attempt to execute the following SQL code to create a stored procedure:
DELIMITER $$

CREATE PROCEDURE test_procedure()
BEGIN
SELECT 'Test 1';
SELECT 'Test 2';
END$$

DELIMITER ;
Observe that the tool throws a syntax error due to the DELIMITER command not being recognized.
Error message: "1064 (42000): 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 $$

CREATE PROCEDURE test_procedure()
BEGIN
SELECT 'Test 1';
S' at line 1"

Azure Data Studio version: azuredatastudio 1.50.0 (49c73a8, 2024-11-17T22:25:36.863Z)
OS version: Darwin arm64 24.2.0
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	Apple M2 (8 x 2400)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	2, 2, 2
Memory (System)	16.00GB (0.07GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (1)

Extension	Author (truncated)	Version
azuredatastudio-mysql	Mic	1.0.0