[Java][JDBC][FlightSql] Select query fails when using JDBC to query Sqlite example
- 主要语言
- Java
- 星标
- 94
- 派生
- 152
- 平均合并
- 3 天 16 小时
- 30 天内合并 PR
- 11
描述
### Describe the bug, including details regarding any error messages, version, and platform.
Running [this example](https://github.com/apache/arrow/blob/main/go/arrow/flight/flightsql/example/cmd/sqlite_flightsql_server/main.go)
I then use DBeaver with the Arrow JDBC Driver

`jdbc:arrow-flight-sql://localhost:53822?useEncryption=false&disableCertificateVerification=true&user=flight_username&password=xxxx`
When running a Select statement and debugging, I see it is performing a Put on the backend and trying to run an Update statement resulting in no data:



If I run a Flight Server using [this example](https://github.com/voltrondata/flight-sql-server-example), and run a Select query, it works fine.
`jdbc:arrow-flight-sql://localhost:31337?useEncryption=true&disableCertificateVerification=true&user=flight_username&password=xxxx`

### Component(s)
Go
贡献指南
调研方向
使用报告中所示的 Go sqlite_flightsql_server 示例、DBeaver 和 Arrow JDBC URL 重现该失败。将其与正常工作的 flight-sql-server-example 进行比较,并追踪 SELECT 被当作更新处理的原因;完成的标准是 SQLite 示例通过 JDBC driver 返回查询行。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- java, sqlite
- 领域
- api, databases
- Issue 类型
- 缺陷
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 35/100