When I was querying based on the Calcite engine, I encountered a problem
Open
- Dominant language
- Java
- Stars
- 5.1k
- Forks
- 1.9k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 46
Description
I used Apache Ignite 2.17.0, Calcite as the SQL parser, and JDK used 17.
During SQL query, the statement is like this: "select * from table1 where (column1, column2) in (value1, value2), (value3, value4)...",
This query will not return results and will remain in the query.
Contributor guide
Research direction
Reproduce the reported query on Apache Ignite 2.17.0 with Calcite as the SQL parser and JDK 17, using the tuple conditions shown in the issue. Compare the behavior with simpler queries and inspect the SQL execution path to identify why this query does not return; done means it completes and returns the expected results.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100