You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2025/10/22 06:21:54 UTC

(doris-website) branch only_full created (now a882f495ad1)

This is an automated email from the ASF dual-hosted git repository.

morrysnow pushed a change to branch only_full
in repository https://gitbox.apache.org/repos/asf/doris-website.git


      at a882f495ad1 [mysql-compability] add sql_mode desc

This branch includes the following new commits:

     new a882f495ad1 [mysql-compability] add sql_mode desc

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


(doris-website) 01/01: [mysql-compability] add sql_mode desc

Posted by mo...@apache.org.
This is an automated email from the ASF dual-hosted git repository.

morrysnow pushed a commit to branch only_full
in repository https://gitbox.apache.org/repos/asf/doris-website.git

commit a882f495ad1ab099d78d556b8a6352d6fab93966
Author: morrySnow <zh...@selectdb.com>
AuthorDate: Wed Oct 22 14:21:30 2025 +0800

    [mysql-compability] add sql_mode desc
---
 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: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org