This is an automated email from the ASF dual-hosted git repository.
zclll pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new acbdfcf482d [feature](func) Support MID function (#2915)
acbdfcf482d is described below
commit acbdfcf482d3b00f4024e8bc1569085ce97ca663
Author: linrrarity <[email protected]>
AuthorDate: Mon Oct 20 10:46:12 2025 +0800
[feature](func) Support MID function (#2915)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/string-functions/substring.md | 14 ++++++++++++++
.../scalar-functions/string-functions/substring.md | 14 ++++++++++++++
2 files changed, 28 insertions(+)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
index 6000ec772e9..5f5cf6a987c 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
@@ -13,6 +13,8 @@ The SUBSTRING function is used to extract a substring from a
string. You can spe
SUBSTR
+MID
+
## Syntax
```sql
@@ -123,4 +125,16 @@ SELECT substring('foobarbar' FROM 4);
+-------------------------------+
| barbar |
+-------------------------------+
+```
+
+8. NULL example with alias MID
+```sql
+SELECT MID(NULL, 2);
+```
+```text
++--------------+
+| MID(NULL, 2) |
++--------------+
+| NULL |
++--------------+
```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
index a3380190ea8..793b187107c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/substring.md
@@ -13,6 +13,8 @@ SUBSTRING 函数用于从字符串中提取子字符串。可以指定起始位
SUBSTR
+MID
+
## 语法
```sql
@@ -123,4 +125,16 @@ SELECT substring('foobarbar' FROM 4);
+-------------------------------+
| barbar |
+-------------------------------+
+```
+
+8. 使用别名MID, 且返回结果为 NULL
+```sql
+SELECT MID(NULL, 2);
+```
+```text
++--------------+
+| MID(NULL, 2) |
++--------------+
+| NULL |
++--------------+
```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
