formulahendry / formulahendry/vscode-mysql
False syntax error in delimiter command
- 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