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 c66a6825f7b [doc] update boolean doc (#3035)
c66a6825f7b is described below
commit c66a6825f7b7837f17e35df3e75721072cf60b46
Author: Mryange <[email protected]>
AuthorDate: Wed Feb 11 03:16:57 2026 +0800
[doc] update boolean doc (#3035)
## Versions
- [x] dev
- [ ] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../sql-data-types/numeric/BOOLEAN.md | 84 ++++++++++++++++++++--
.../sql-data-types/numeric/BOOLEAN.md | 81 +++++++++++++++++++--
2 files changed, 154 insertions(+), 11 deletions(-)
diff --git a/docs/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
b/docs/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
index 056001f42fc..93a87abe633 100644
--- a/docs/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
+++ b/docs/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
@@ -6,10 +6,82 @@
}
---
-## BOOLEAN
-### Description
-BOOL, BOOLEAN
-Like TINYINT, 0 stands for false and 1 for true.
+## Description
+
+BOOLEAN (alias: BOOL) is a data type in Doris that represents boolean values:
true and false.
+
+Internally, BOOLEAN is stored as a uint8 value, where 0 represents false and 1
represents true.
+
+Unlike MySQL where BOOLEAN is an alias for TINYINT(1), Doris treats BOOLEAN as
a separate data type, similar to PostgreSQL, Oracle, and other database systems.
+
+## Value Range
+
+BOOLEAN values can only be:
+- `true` (represented as 1 when displayed)
+- `false` (represented as 0 when displayed)
+
+In memory, BOOLEAN type only exists as 0 or 1, with no other possible values.
+
+## Literal Values
+
+In Doris, you can use the keywords `true` and `false` (case-insensitive) to
represent boolean literal values:
+
+```sql
+mysql> select TrUe, False, true;
++------+-------+------+
+| TrUe | False | true |
++------+-------+------+
+| 1 | 0 | 1 |
++------+-------+------+
+```
+
+## Supported Operations
+
+### Logical Operations
+
+BOOLEAN type supports logical operations such as AND, OR, NOT, and XOR:
-### keywords
-BOOLEAN
+```sql
+mysql> select true AND false, true OR false, NOT true, true XOR false;
++----------------+---------------+----------+----------------+
+| true AND false | true OR false | NOT true | true XOR false |
++----------------+---------------+----------+----------------+
+| 0 | 1 | 0 | 1 |
++----------------+---------------+----------+----------------+
+```
+
+### Arithmetic Operations
+
+While BOOLEAN doesn't directly support arithmetic operations, expressions like
`true + true` will work due to implicit type conversion:
+
+```sql
+mysql> select true + true;
++-------------+
+| true + true |
++-------------+
+| 2 |
++-------------+
+```
+
+This works because the boolean values are implicitly cast to SMALLINT:
`CAST(TRUE AS smallint) + CAST(TRUE AS smallint)`.
+
+## Type Conversion
+
+It's important to note that BOOLEAN is not equivalent to TINYINT in Doris,
even though they may appear similar due to MySQL conventions.
+
+When inserting a boolean literal into a TINYINT column, implicit type
conversion occurs:
+
+```sql
+CREATE TABLE test_boolean(
+ u8 TINYINT
+)
+properties("replication_num" = "1");
+
+mysql> insert into test_boolean values(true);
+```
+
+In this example, the boolean literal `true` is converted to a TINYINT value.
+
+## Keywords
+
+BOOL, BOOLEAN
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
index dfdd2c56e83..01147f8ea68 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/BOOLEAN.md
@@ -6,11 +6,82 @@
}
---
-## BOOLEAN
## 描述
- BOOL, BOOLEAN
- 与TINYINT一样，0代表false，1代表true
-### keywords
+BOOLEAN 是 Doris 中表示布尔值的数据类型：真值和假值。
- BOOLEAN
+在内部，BOOLEAN 被存储为 uint8 值，其中 0 表示 false（假），1 表示 true（真）。
+
+与 MySQL 中 BOOLEAN 是 TINYINT(1) 的别名不同，Doris 将 BOOLEAN 作为一个独立的数据类型处理，类似于
PostgreSQL、Oracle 和其他数据库系统。
+
+## 取值范围
+
+BOOLEAN 值只能是：
+- `true`（显示时表示为 1）
+- `false`（显示时表示为 0）
+
+在内存中，BOOLEAN 类型只存在 0 或 1，没有其他可能的值。
+
+## 字面量
+
+在 Doris 中，您可以使用关键字 `true` 和 `false`（不区分大小写）来表示布尔字面量：
+
+```sql
+mysql> select TrUe, False, true;
++------+-------+------+
+| TrUe | False | true |
++------+-------+------+
+| 1 | 0 | 1 |
++------+-------+------+
+```
+
+## 支持的操作
+
+### 逻辑运算
+
+BOOLEAN 类型支持逻辑运算，如 AND、OR、NOT 和 XOR：
+
+```sql
+mysql> select true AND false, true OR false, NOT true, true XOR false;
++----------------+---------------+----------+----------------+
+| true AND false | true OR false | NOT true | true XOR false |
++----------------+---------------+----------+----------------+
+| 0 | 1 | 0 | 1 |
++----------------+---------------+----------+----------------+
+```
+
+### 算术运算
+
+虽然 BOOLEAN 类型不直接支持算术运算，但像 `true + true` 这样的表达式会由于隐式类型转换而生效：
+
+```sql
+mysql> select true + true;
++-------------+
+| true + true |
++-------------+
+| 2 |
++-------------+
+```
+
+这是因为布尔值被隐式转换为 SMALLINT：`CAST(TRUE AS smallint) + CAST(TRUE AS smallint)`。
+
+## 类型转换
+
+需要注意的是，在 Doris 中，BOOLEAN 与 TINYINT 不等价，尽管它们由于 MySQL 的习惯可能看起来相似。
+
+当将布尔字面量插入到 TINYINT 列时，会发生隐式类型转换：
+
+```sql
+CREATE TABLE test_boolean(
+ u8 TINYINT
+)
+properties("replication_num" = "1");
+
+mysql> insert into test_boolean values(true);
+```
+
+在这个例子中，布尔字面量 `true` 被转换为 TINYINT 值。
+
+## 关键字
+
+BOOL, BOOLEAN
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
