matrixorigin / matrixorigin/matrixone
[MO Feature]: 支持 SELECT ... INTO DUMPFILE 语法(MySQL 兼容)
Open
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
Assessment
This issue has not been assessed yet.