apache / apache/arrow-java

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

未关闭
#114 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Java
星标
94
派生
152
平均合并
3 天 16 小时
30 天内合并 PR
11

描述

### 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

贡献指南

打开贡献指南

调研方向

首先,使用报告的 15.0.2 版本,通过 FlightRPC 和 flight-jdbc 组件重现所提供的查询,然后跟踪运行时创建的列的参数是如何处理的。该 issue 未指定源文件或测试;当查询能够使用所提供的动态参数成功执行,并且有一个回归测试覆盖此行为时,即表示完成。

由索引模型根据 Issue 内容生成。

评估

技术栈
java, sql
领域
api, database
Issue 类型
缺陷
难度
4/5
预计耗时
3-5 天
活跃度
停滞
描述清晰度
需要澄清
新手友好度
35/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。