apache / apache/arrow-java

[flight-rpc][flight-jdbc][sql] - Dynamic parameters on columns that created in runtime not working

Open
#114 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
94
Forks
152
Avg merge
3d 16h
Merged PRs (30d)
11

Description

### Describe the bug, including details regarding any error messages, version, and platform.

Here's an example of code that causes the issue:
```## Doesn't work when the params are set on a created column on the fly
# stmt = text("SELECT *, (CASE WHEN (`OID` IS NULL) THEN :x ELSE :y END) as Temp FROM `Dynamic.Schema.Dts`.`Table`")
# rows = con.execute(stmt, {'x': 1, 'y': 0}).fetchall()
```

I'm unable to select with this query because I create a column on fly in runtime, after it's created I would like to query it.
And it's seems impossible.

I've tested it with: 15.0.2 and it still has the same issue.

Thank you in advance for the help.
If anymore information is required please comment that.

### Component(s)

FlightRPC, Java, Other

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the provided query through the FlightRPC and flight-jdbc components using the reported 15.0.2 version, then trace how parameters are handled for runtime-created columns. The issue does not name a source file or test; done means the query executes successfully with the supplied dynamic parameters and a regression test covers the behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
api, 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.