go-sql-driver/mysql

Implement cursor support

Open

#1,053 建立於 2020年1月7日

在 GitHub 查看
 (4 留言) (7 反應) (0 負責人)Go (9,946 star) (1,789 fork)batch import
database/sql issueenhancementhelp wanted

描述

Issue description

In some cases it might be undesirable to fetch a potentially huge resultset at once.

MySQL provides cursors for that in the binary protocol (prepared statements).

First, a cursor flag has to be set in COM_STMT_EXECUTE, then the result chunks can be requested with the COM_STMT_FETCH command.

Initially, we will probably only support forward-only and read-only cursors. However the question remains, trough what interface we make this feature available.

貢獻者指南

技術棧
gomysql
領域
backenddatabase
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
4
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
over 1 week
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Go programmingMySQL protocol
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
35
研究方向
Implement cursor support by setting the cursor flag in COM STMT EXECUTE and using COM STMT FETCH. Refer to MySQL internals documentation (https://dev.mysql.com/doc/internals/en/com stmt execute.html and https://dev.mysql.com/doc/internals/en/com stmt fetch.html). The main question is the interface; consider forward only and read only cursors. Look at existing comments for design ideas.