taozhi8833998 / taozhi8833998/node-sql-parser
[MySQL] SELECT DISTINCTROW is not handled properly
Open
@taozhi8833998 is already working on this.
Since Sep 15, 2026.
- Dominant language
- PEG.js
- Stars
- 1k
- Forks
- 244
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
SELECT DISTINCTROW is not handled properly
Expected a separator before "status"
Database Engine
MySQL
To Reproduce
-SELECT DISTINCTROW status FROM ppc.keywords LIMIT 20
-node-sql-parser v5.4.0
-v24.21.0
Expected behavior
It should work without any error message
In MySQL, DISTINCTROW is effectively a synonym for DISTINCT.
Contributor guide
No contributing guide indexed for this repository
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.
Assessment
This issue has not been assessed yet.