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.
Implement cursor support · go-sql-driver/mysql#1053 | Good First Issue