[flight-rpc][flight-jdbc][sql] - Dynamic parameters on columns that created in runtime not working
- 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
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