Nested queries are throwing exception
- Dominant language
- Java
- Stars
- 5.1k
- Forks
- 1.9k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 46
Description
I am using the JDBC thin driver for accessing my Ignite DB but I am having issues with nested queries:
This nested query works on a given OrderDetails table:
```
SELECT ORDERNUMBER AS xx__rs_col_0 FROM (
SELECT * FROM OrderDetails
) colQry
```
but adding one more level does not work:
```
SELECT xx__rs_col_0 FROM (
SELECT ORDERNUMBER AS xx__rs_col_0 FROM (
SELECT * FROM OrderDetails
) colQry
) aliasQry
```
as I get this error:
`Exception in thread "main" java.sql.SQLException: class org.apache.ignite.IgniteCheckedException: null
at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1010)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.executeQuery(JdbcThinStatement.java:142)
at infofabrik.Main.main(Main.java:25)`
Any ideas what may be going wrong here? is this supported ? Using ignite-core 2.14.0
Contributor guide
Research direction
Reproduce the two nested queries against Ignite 2.14.0 using the JDBC thin driver, then inspect the failure path beginning at JdbcThinStatement.java and JdbcThinConnection.java; Main.java:25 is the reported call site. Done means establishing whether the deeper nesting is supported and documenting or correcting the behavior with a reliable regression check.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100