phpmyadmin / phpmyadmin/sql-parser
Subqueries in WHERE clause
Open
Nobody has claimed this yet.
bug
enhancement
- Dominant language
- PHP
- Stars
- 485
- Forks
- 119
- PR merge metrics
- No merged PRs in 30d
Description
The parser doesn't seem to identify subqueries in where clauses, such as:
SELECT * FROM tableA WHERE id IN (SELECT id FROM tableB)
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
Reproduce the supplied SQL query with the parser and trace how WHERE expressions and nested SELECTs are handled. The issue names no file or test, so locate the relevant parser coverage first. Done means the subquery in the WHERE clause is identified correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, sql
- Domain
- compilers, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100