DELIMITER throws a 1064 error about azuredatastudio-mysql HOT 3 OPEN

Hi @bradlis7,

I am looking at the delimiter syntax why it did not work.

Can you try the following script as a work around:

drop procedure if exists MyProc;
create procedure MyProc()
begin
	if (DATABASE() = 'X')
	then
		insert into CustomerSetting (CustomerId, `Key`, `Value`) values (10, 'Setting', 'false');
	end if;

	if (DATABASE() = 'T')
	then
		insert into CustomerSetting (CustomerId, `Key`, `Value`) values (20, 'Setting', 'false');
	end if;

end;


-- Execute the procedure
call MyProc();

-- Drop the procedure
drop procedure MyProc;

from azuredatastudio-mysql.

Looks like it does work without DELIMITER. And my script app seems to accept it without DELIMITER, so I probably don't need this personally anymore, but it might be nice for others if it was supported. If you'd like to close it, feel free.

from azuredatastudio-mysql.

Actually, I mispoke... it worked once I think, but doesn't work, so I do need DELIMITER support.

from azuredatastudio-mysql.