pingcap/tidb

Add LOAD_FILE() function

Open

#8,436 建立於 2018年11月24日

在 GitHub 查看
 (1 留言) (0 反應) (1 負責人)Go (40,090 star) (6,186 fork)batch import
help wantedpriority/P4type/compatibility

描述

Feature Request

Is your feature request related to a problem? Please describe:

Not a high priority, but apart from SOUNDEX() the LOAD_FILE function is the only string function not supported by TiDB.

In MySQL it is rarely used because of security implications.

Describe the feature you'd like:

LOAD_FILE as in MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_load-file

Describe alternatives you've considered:

The alternative is to document as won't support.

Teachability, Documentation, Adoption, Migration Strategy:

貢獻者指南

技術棧
gosql
領域
databasebackend
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-2 days
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
blocked
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Knowledge of TiDB expression evaluationFamiliarity with MySQL string functions
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
25
研究方向
Review existing string function implementations in TiDB's expression package (e.g., SOUNDEX). Implement LOAD FILE following MySQL 5.7 documentation, handling file reading and security restrictions. Add tests for various file scenarios.