apache / apache/ignite

Nested queries are throwing exception

Open
#10,590 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.