matrixorigin / matrixorigin/matrixone

[MO Feature]: 支持 SELECT ... INTO DUMPFILE 语法(MySQL 兼容)

Open
#24,506 0 comments 0 reactions 1 assignee Claimed by @jiangxinmeng1 View on GitHub
ai-easy kind/compatibility non-mysql-compatible priority/p0
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

**Is your feature request related to a problem?**
执行 SELECT FROM_BASE64(zaddr2) INTO DUMPFILE '/tmp/test.pdf' 报语法错误,MySQL 支持此语法用于将单行二进制数据直接导出为文件。

**Describe the feature you'd like**
支持 SELECT ... INTO DUMPFILE 语法,允许将查询结果直接写出到服务端文件。

**Describe implementation you've considered**
当前绕过方案:通过应用层(Python/Java)查询结果后手动写文件。

**Documentation, Adoption, Use Case, Migration Strategy**
MySQL 迁移用户常用此语法导出二进制文件(BLOB/PDF等),缺失此功能会增加迁移成本。

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.