This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 353835618ed [mysql-compatability] add sql_mode desc (#2997)
353835618ed is described below
commit 353835618edc71d63f47210dcc1d43b82353af7f
Author: morrySnow <[email protected]>
AuthorDate: Thu Oct 23 11:27:59 2025 +0800
[mysql-compatability] add sql_mode desc (#2997)
## Versions
- [x] dev
- [x] 3.x
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [x] Checked by AI
- [ ] Test Cases Built
---
docs/query-data/mysql-compatibility.md | 8 ++++++++
.../current/query-data/mysql-compatibility.md | 8 ++++++++
.../version-2.1/query-data/mysql-compatibility.md | 7 +++++++
.../version-3.x/query-data/mysql-compatibility.md | 8 ++++++++
versioned_docs/version-2.1/query-data/mysql-compatibility.md | 7 +++++++
versioned_docs/version-3.x/query-data/mysql-compatibility.md | 8 ++++++++
6 files changed, 46 insertions(+)
diff --git a/docs/query-data/mysql-compatibility.md
b/docs/query-data/mysql-compatibility.md
index f31dd49a6de..77b846f8d56 100644
--- a/docs/query-data/mysql-compatibility.md
+++ b/docs/query-data/mysql-compatibility.md
@@ -259,3 +259,11 @@ The Doris SELECT syntax is basically the same as MySQL.
## SQL Function
Doris Function covers most MySQL functions.
+
+## SQL Mode
+
+| Name | Behavior when enabled | Behavior when disabled | Notes |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| NO_BACKSLASH_ESCAPES | Treats backslashes in strings as literal characters |
Treats backslashes in strings as escape characters | - |
+| ONLY_FULL_GROUP_BY | Allows only standard aggregations | Allows scalar
values not in the GROUP BY key to appear in the aggregation result | Supported
since version 3.1.0 |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/mysql-compatibility.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/mysql-compatibility.md
index 7667b53019b..eab1018e2f5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/mysql-compatibility.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/mysql-compatibility.md
@@ -260,3 +260,11 @@ Doris Select 语法与 MySQL 基本一致
## SQL Function
Doris Function 基本覆盖绝大部分 MySQL Function。
+
+## SQL Mode
+
+| 名称 | 设置的行为 | 未设置的行为 | 备注 |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
+| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/mysql-compatibility.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/mysql-compatibility.md
index 7667b53019b..a5f903d883a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/mysql-compatibility.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/mysql-compatibility.md
@@ -260,3 +260,10 @@ Doris Select 语法与 MySQL 基本一致
## SQL Function
Doris Function 基本覆盖绝大部分 MySQL Function。
+
+## SQL Mode
+
+| 名称 | 设置的行为 | 未设置的行为 | 备注 |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-data/mysql-compatibility.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-data/mysql-compatibility.md
index 7667b53019b..eab1018e2f5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-data/mysql-compatibility.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-data/mysql-compatibility.md
@@ -260,3 +260,11 @@ Doris Select 语法与 MySQL 基本一致
## SQL Function
Doris Function 基本覆盖绝大部分 MySQL Function。
+
+## SQL Mode
+
+| 名称 | 设置的行为 | 未设置的行为 | 备注 |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
+| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
\ No newline at end of file
diff --git a/versioned_docs/version-2.1/query-data/mysql-compatibility.md
b/versioned_docs/version-2.1/query-data/mysql-compatibility.md
index f31dd49a6de..2e3fc25271d 100644
--- a/versioned_docs/version-2.1/query-data/mysql-compatibility.md
+++ b/versioned_docs/version-2.1/query-data/mysql-compatibility.md
@@ -259,3 +259,10 @@ The Doris SELECT syntax is basically the same as MySQL.
## SQL Function
Doris Function covers most MySQL functions.
+
+## SQL Mode
+
+| Name | Behavior when enabled | Behavior when disabled | Notes |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| NO_BACKSLASH_ESCAPES | Treats backslashes in strings as literal characters |
Treats backslashes in strings as escape characters | - |
\ No newline at end of file
diff --git a/versioned_docs/version-3.x/query-data/mysql-compatibility.md
b/versioned_docs/version-3.x/query-data/mysql-compatibility.md
index f31dd49a6de..77b846f8d56 100644
--- a/versioned_docs/version-3.x/query-data/mysql-compatibility.md
+++ b/versioned_docs/version-3.x/query-data/mysql-compatibility.md
@@ -259,3 +259,11 @@ The Doris SELECT syntax is basically the same as MySQL.
## SQL Function
Doris Function covers most MySQL functions.
+
+## SQL Mode
+
+| Name | Behavior when enabled | Behavior when disabled | Notes |
+| :-- | :-- | :-- | :-- |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| NO_BACKSLASH_ESCAPES | Treats backslashes in strings as literal characters |
Treats backslashes in strings as escape characters | - |
+| ONLY_FULL_GROUP_BY | Allows only standard aggregations | Allows scalar
values not in the GROUP BY key to appear in the aggregation result | Supported
since version 3.1.0 |
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
