Tuple in WHERE clause
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 17.3k
- Forks
- 1.6k
- Avg merge
- 5d 10h
- Merged PRs (30d)
- 28
Description
Is your feature request related to a problem?
When I want to filter by value pairs, I have to type there WHERE clause like this:
WHERE (c1 = 'a' AND c2 = 'x') OR (c1 = 'b' AND c2 = 'z')
Describe the solution you'd like.
I believe it would be more practical to support filtering by value pairs using tuples, like:
WHERE (c1, c2) IN (('a', 'x'), ('b', 'z'))
This approach is easier to generate and maintain, especially with many pairs.
Describe alternatives you've considered.
No response
Full Name:
Raul
Affiliation:
No affiliation
Additional context
No response
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 provides no file, test, or entry point to inspect. Begin by locating the SQL WHERE-clause parsing and execution paths, then add coverage for tuple comparisons such as (c1, c2) IN (('a', 'x'), ('b', 'z')); done means those queries filter the matching value pairs correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100