formulahendry / formulahendry/vscode-mysql

False syntax error in delimiter command

Open
#113 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
229
Forks
58
PR merge metrics
No merged PRs in 30d

Description

DROP PROCEDURE IF EXISTS agregarCarrera;
DELIMITER //
CREATE PROCEDURE agregarCarrera(IN Nombre_ VARCHAR(60))
BEGIN
INSERT INTO Carreras (Nombre) VALUES (Nombre_);
SELECT last_insert_id() AS UltimoID;
END
//
DELIMITER ;

[Start] Executing MySQL query...
Error: ER_PARSE_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 //
CREATE PROCEDURE agregarCarrera(IN Nombre_ VARCHAR(60))
BEGIN
' at line 1
[Done] Finished MySQL query.

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the report using the supplied MySQL procedure and DELIMITER commands in the VS Code extension. Trace how the query is submitted to MySQL, then verify that this valid procedure script is handled without the reported syntax error and that ordinary queries still execute correctly.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, typescript
Domain
database, tooling
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.