sql-formatter-org / sql-formatter-org/sql-formatter
mysql: create procedure LOOP bug
Open
Nobody has claimed this yet.
bug
mysql/mariadb
- Dominant language
- TypeScript
- Stars
- 2.9k
- Forks
- 456
- Avg merge
- 3d 4h
- Merged PRs (30d)
- 3
Description
label:
LOOP
FETCH cur_1 INTO
event_id,only_code,garage,space;
IF done THEN
LEAVE label;
END IF;
set @SqlStmtA1 = concat('delete from ', eventtablename, ' where id=', event_id);
prepare stmtA1 FROM @SqlStmtA1;
EXECUTE stmtA1;
COMMIT;
END LOOP;
CLOSE cur_1;
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue mentions only a MySQL procedure example and a screenshot; no source file or test is identified. Start by reproducing the example and locating the MySQL formatting entry point, then add a regression test for the LOOP case. Done means the procedure formats validly while preserving its control-flow structure.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100