apache / apache/arrow-java

[Java][JDBC][FlightSql] Select query fails when using JDBC to query Sqlite example

未關閉
#165 8 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
主要語言
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
![image](https://github.com/apache/arrow-java/assets/6108819/37254b9e-6326-4725-8434-94d3ae9f374e)

`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:
![image](https://github.com/apache/arrow-java/assets/6108819/be4c9388-0436-4925-8d53-c7421583d1c1)

![image](https://github.com/apache/arrow-java/assets/6108819/4ac8f601-843f-42fb-b03d-56db7e6c015b)

![image](https://github.com/apache/arrow-java/assets/6108819/461021bb-b523-4485-b38a-a8729d5b3ea3)

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`
![image](https://github.com/apache/arrow-java/assets/6108819/ab6fa95d-0eb7-4b2f-a8b9-d01d2b92ebc4)

### Component(s)

Go

貢獻指南

開啟貢獻指南

研究方向

使用報告中所示的 Go sqlite_flightsql_server example、DBeaver 和 Arrow JDBC URL 重現此失敗。將其與正常運作的 flight-sql-server-example 比較,並追查 SELECT 被當作更新處理的原因;完成的標準是 SQLite example 透過 JDBC driver 傳回查詢列。

由索引模型根據 Issue 內容生成。

評估

技術堆疊
java, sqlite
領域
api, databases
Issue 類型
缺陷
難度
4/5
預估耗時
3-5 天
活躍度
停滯
描述清晰度
基本清楚
新手友好度
35/100

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。