This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 071c6bf9046 fix: SQL mode behavior description for PIPES_AS_CONCAT
(#3381)
071c6bf9046 is described below
commit 071c6bf9046ba6e526e20b78c2e9bfe9406534ea
Author: Yongqiang YANG <[email protected]>
AuthorDate: Tue Feb 10 14:05:38 2026 -0800
fix: SQL mode behavior description for PIPES_AS_CONCAT (#3381)
## Summary
- Correct `PIPES_AS_CONCAT` behavior description: when not enabled, `||`
should be parsed as logical **OR** (not logical AND).
- Apply the fix across `dev`, `3.x`, and `4.x` for both English and
Chinese docs.
## Versions
- [x] dev
- [x] 4.x
- [x] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Reference
- Original PR: https://github.com/apache/doris-website/pull/3199
Co-authored-by: Felix021 <[email protected]>
---
docs/query-data/mysql-compatibility.md | 4 ++--
.../current/query-data/mysql-compatibility.md | 4 ++--
.../version-3.x/query-data/mysql-compatibility.md | 4 ++--
.../version-4.x/query-data/mysql-compatibility.md | 4 ++--
versioned_docs/version-3.x/query-data/mysql-compatibility.md | 4 ++--
versioned_docs/version-4.x/query-data/mysql-compatibility.md | 4 ++--
6 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/docs/query-data/mysql-compatibility.md
b/docs/query-data/mysql-compatibility.md
index 005b7bbfeab..23c1ce084af 100644
--- a/docs/query-data/mysql-compatibility.md
+++ b/docs/query-data/mysql-compatibility.md
@@ -265,6 +265,6 @@ Doris Function covers most MySQL functions.
| Name | Behavior when enabled | Behavior when disabled | Notes |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical OR 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
+| 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 |
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 64b27b486e2..0db33e3560a 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
@@ -266,6 +266,6 @@ Doris Function 基本覆盖绝大部分 MySQL Function。
| 名称 | 设置的行为 | 未设置的行为 | 备注 |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑或操作符 | - |
| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
-| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
\ No newline at end of file
+| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
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 43a910cb785..8adaee55724 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
@@ -266,6 +266,6 @@ Doris Function 基本覆盖绝大部分 MySQL Function。
| 名称 | 设置的行为 | 未设置的行为 | 备注 |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑或操作符 | - |
| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
-| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
\ No newline at end of file
+| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/mysql-compatibility.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/mysql-compatibility.md
index 43a910cb785..8adaee55724 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/mysql-compatibility.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/mysql-compatibility.md
@@ -266,6 +266,6 @@ Doris Function 基本覆盖绝大部分 MySQL Function。
| 名称 | 设置的行为 | 未设置的行为 | 备注 |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑与操作符 | - |
+| PIPES_AS_CONCAT | 将 `\|\|` 符号解析为 concat 函数 | 将 `\|\|` 符号解析为逻辑或操作符 | - |
| NO_BACKSLASH_ESCAPES | 将字符串中的反斜杠当做正常字符解析 | 将字符串中的反斜杠当做转义起始字符 | - |
-| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
\ No newline at end of file
+| ONLY_FULL_GROUP_BY | 只允许标准的聚合 | 允许聚合结果输出中包含不在聚合 KEY 中的标量值 | 自 3.1.0 版本开始支持 |
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 ecc952afcc6..24c3fd23c0e 100644
--- a/versioned_docs/version-3.x/query-data/mysql-compatibility.md
+++ b/versioned_docs/version-3.x/query-data/mysql-compatibility.md
@@ -265,6 +265,6 @@ Doris Function covers most MySQL functions.
| Name | Behavior when enabled | Behavior when disabled | Notes |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical OR 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
+| 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 |
diff --git a/versioned_docs/version-4.x/query-data/mysql-compatibility.md
b/versioned_docs/version-4.x/query-data/mysql-compatibility.md
index ecc952afcc6..24c3fd23c0e 100644
--- a/versioned_docs/version-4.x/query-data/mysql-compatibility.md
+++ b/versioned_docs/version-4.x/query-data/mysql-compatibility.md
@@ -265,6 +265,6 @@ Doris Function covers most MySQL functions.
| Name | Behavior when enabled | Behavior when disabled | Notes |
| :-- | :-- | :-- | :-- |
-| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical AND operator | - |
+| PIPES_AS_CONCAT | Parses `\|\|` as the `concat` function | Parses `\|\|` as
the logical OR 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
+| 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 |
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
