This is an automated email from the ASF dual-hosted git repository.
csun5285 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 87d33c245f9 [doc](sql) Clarify complex type IN/NOT IN restrictions
(#4328)
87d33c245f9 is described below
commit 87d33c245f959a98b31969dfbc9196eccca43da9
Author: Chenyang Sun <[email protected]>
AuthorDate: Fri Oct 16 14:37:01 2026 +0800
[doc](sql) Clarify complex type IN/NOT IN restrictions (#4328)
## Proposed changes
- Document that `IN` and `NOT IN` accept scalar primitive values only.
- Explain that complex types such as `ARRAY`, `MAP`, and `STRUCT` cannot
appear in an `IN` predicate.
- Add invalid examples and type-specific restrictions to the ARRAY, MAP,
and STRUCT documentation.
- Update both the current (dev) and 4.x documentation; the 4.x
documentation covers Doris 4.2.
---
.../operators/conditional-operators/in-operators.md | 14 +++++++++++++-
.../basic-element/sql-data-types/semi-structured/ARRAY.md | 1 +
.../basic-element/sql-data-types/semi-structured/MAP.md | 2 +-
.../basic-element/sql-data-types/semi-structured/STRUCT.md | 2 +-
.../operators/conditional-operators/in-operators.md | 14 +++++++++++++-
.../basic-element/sql-data-types/semi-structured/ARRAY.md | 1 +
.../basic-element/sql-data-types/semi-structured/MAP.md | 2 +-
.../basic-element/sql-data-types/semi-structured/STRUCT.md | 2 +-
.../operators/conditional-operators/in-operators.md | 14 +++++++++++++-
.../basic-element/sql-data-types/semi-structured/ARRAY.md | 1 +
.../basic-element/sql-data-types/semi-structured/MAP.md | 2 +-
.../basic-element/sql-data-types/semi-structured/STRUCT.md | 2 +-
.../operators/conditional-operators/in-operators.md | 14 +++++++++++++-
.../basic-element/sql-data-types/semi-structured/ARRAY.md | 1 +
.../basic-element/sql-data-types/semi-structured/MAP.md | 2 +-
.../basic-element/sql-data-types/semi-structured/STRUCT.md | 2 +-
16 files changed, 64 insertions(+), 12 deletions(-)
diff --git
a/docs/sql-manual/basic-element/operators/conditional-operators/in-operators.md
b/docs/sql-manual/basic-element/operators/conditional-operators/in-operators.md
index 84ab00ef6a0..e30f93fe012 100644
---
a/docs/sql-manual/basic-element/operators/conditional-operators/in-operators.md
+++
b/docs/sql-manual/basic-element/operators/conditional-operators/in-operators.md
@@ -15,4 +15,16 @@ The IN operator tests whether a value is a member of a list
of values or a subqu
| Operator | Function | Example |
| ------- | ------------------------------------------------ |
------------------------------ |
| IN | Tests if it is equal to any member. Returns TRUE if so. | `SELECT 1
IN (SELECT 2)` |
-| NOT IN | Tests if it is not equal to all members. Returns TRUE if so. |
`SELECT 1 NOT IN (3, 4, 5)` |
\ No newline at end of file
+| NOT IN | Tests if it is not equal to all members. Returns TRUE if so. |
`SELECT 1 NOT IN (3, 4, 5)` |
+
+## Type Constraints
+
+`IN` and `NOT IN` support scalar primitive values only. Complex types such as
`ARRAY`, `MAP`, and `STRUCT`, as well as object types, cannot be used as the
left-hand expression or as values in the `IN` list.
+
+For example, the following statements are invalid:
+
+```sql
+SELECT STRUCT(1, 2) IN (STRUCT(1, 2));
+SELECT [1, 2] IN ([1, 2]);
+SELECT MAP('a', 1) IN (MAP('a', 1));
+```
diff --git
a/docs/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
b/docs/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
index 95d269a81dd..3a7a374916d 100644
--- a/docs/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
+++ b/docs/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
@@ -26,6 +26,7 @@ The `ARRAY<T>` type is used to represent an ordered
collection of elements, wher
- In the `AGGREGATE` table model, `ARRAY<T>` type only supports `REPLACE` and
`REPLACE_IF_NOT_NULL`. **In any table model, it cannot be used as a KEY column,
nor as a partition or bucket column**.
- Columns of `ARRAY<T>` type **support `ORDER BY` and `GROUP BY` operations**.
- T types that support `ORDER BY` and `GROUP BY` include: `BOOLEAN, TINYINT,
SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME,
TIMESTAMP_NS, TIMESTAMPTZ, CHAR, VARCHAR, STRING, IPV4, IPV6, UUID`.
+- Columns of `ARRAY<T>` type do not support `IN` or `NOT IN` operations.
- Columns of `ARRAY<T>` type do not support being used as `JOIN KEY` and do
not support being used in `DELETE` statements.
## Constant Construction
diff --git
a/docs/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
b/docs/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
index 714df555cbe..e6293f7b908 100644
--- a/docs/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
+++ b/docs/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
@@ -23,7 +23,7 @@
- For example: `MAP<INT, INT>` can be converted to `MAP<BIGINT, BIGINT>`
because `INT` and `BIGINT` can be converted.
- String types can be converted to `MAP<key_type, value_type>` (through
parsing, returning NULL if parsing fails).
- In the `AGGREGATE` table model, `MAP<key_type, value_type>` only supports
`REPLACE` and `REPLACE_IF_NOT_NULL`. **In any table model, it cannot be used as
a KEY column, nor as a partition or bucket column**.
-- Columns of type `MAP<key_type, value_type>` do not support comparison or
arithmetic operations, **do not support `ORDER BY` and `GROUP BY` operations,
cannot be used as `JOIN KEY`, and cannot be used in `DELETE` statements**.
+- Columns of type `MAP<key_type, value_type>` do not support comparison or
arithmetic operations, including `IN` and `NOT IN`, **do not support `ORDER BY`
and `GROUP BY` operations, cannot be used as `JOIN KEY`, and cannot be used in
`DELETE` statements**.
- Columns of type `MAP<key_type, value_type>` do not support creating any
indexes.
## Type Construction
diff --git
a/docs/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
b/docs/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
index b0ceee7e74f..8fa8de8672f 100644
--- a/docs/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
+++ b/docs/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
@@ -31,7 +31,7 @@ The STRUCT type is used to combine multiple fields into a
single structure, wher
- In the `AGGREGATE` table model, `STRUCT` types only support `REPLACE` and
`REPLACE_IF_NOT_NULL`. **In any table model, they cannot be used as KEY
columns, nor as partition or bucket columns.**
-- Columns of `STRUCT` type do not support comparison or arithmetic operations,
**do not support `ORDER BY` and `GROUP BY` operations, cannot be used as `JOIN
KEY`, and cannot be used in `DELETE` statements.**
+- Columns of `STRUCT` type do not support comparison or arithmetic operations,
including `IN` and `NOT IN`, **do not support `ORDER BY` and `GROUP BY`
operations, cannot be used as `JOIN KEY`, and cannot be used in `DELETE`
statements.**
- Columns of `STRUCT` type do not support creating any indexes.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/operators/conditional-operators/in-operators.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/operators/conditional-operators/in-operators.md
index a82f58603a4..2bb5f6b7ea3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/operators/conditional-operators/in-operators.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/operators/conditional-operators/in-operators.md
@@ -15,4 +15,16 @@ IN 操作符测试一个值是否属于某个值列表或子查询中的成员
| 操作符 | 作用 | 示例
|
| ------ | ----------------------------------------------- |
--------------------------- |
| IN | 测试是否等于任意的成员。如果是，则返回 TRUE。 | `SELECT 1 IN (SELECT 2)` |
-| NOT IN | 测试是否不等于所有的成员。如果是，则返回 TRUE。 | `SELECT 1 NOT IN (3, 4, 5)` |
\ No newline at end of file
+| NOT IN | 测试是否不等于所有的成员。如果是，则返回 TRUE。 | `SELECT 1 NOT IN (3, 4, 5)` |
+
+## 类型限制
+
+`IN` 和 `NOT IN` 仅支持标量基本类型。`ARRAY`、`MAP` 和 `STRUCT` 等复杂类型，以及对象类型，不能作为左侧表达式或
`IN` 列表中的值。
+
+以下语句无效：
+
+```sql
+SELECT STRUCT(1, 2) IN (STRUCT(1, 2));
+SELECT [1, 2] IN ([1, 2]);
+SELECT MAP('a', 1) IN (MAP('a', 1));
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
index 055f8a52246..4cf07827029 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
@@ -26,6 +26,7 @@
-
`ARRAY<T>`类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为KEY列，无法作为分区分桶列**。
- `ARRAY<T>`类型的列**支持`ORDER BY`和`GROUP BY`操作**。
- 支持`ORDER BY`和`GROUP
BY`的T类型包括：`BOOLEAN,TINYINT,SMALLINT,INT,BIGINT,LARGEINT,FLOAT,DOUBLE,DECIMAL,DATE,DATETIME,TIMESTAMP_NS,TIMESTAMPTZ,CHAR,VARCHAR,STRING,IPTV4,IPV6,UUID`。
+- `ARRAY<T>`类型的列不支持`IN`或`NOT IN`操作。
- `ARRAY<T>`类型的列不支持作为 `JOIN KEY`，不支持在`DELETE`语句中使用。
## 常量构造
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
index 9586c54be3a..f82eaf78a1b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
@@ -25,7 +25,7 @@
- 例如: `MAP<INT,INT>`可以转换为`MAP<BIGINT,BIGINT>`，因为`INT`和`BIGINT`可以转换。
- 字符串类型可以转换成`MAP<key_type, value_type>`类型（通过解析的形式，解析失败返回 NULL）。
- `MAP<key_type, value_type>`
类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为`Key`列，无法作为分区分桶列**。
-- `MAP<key_type, value_type>`类型的列不支持比较或者算数运算，**不支持`ORDER BY`和`GROUP
BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
+- `MAP<key_type, value_type>`类型的列不支持比较或者算数运算，包括`IN`和`NOT IN`，**不支持`ORDER
BY`和`GROUP BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
- `MAP<key_type, value_type>`类型的列不支持建立任何索引。
## 类型构造
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
index f6259bf6491..130aec0ef43 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
@@ -22,7 +22,7 @@ STRUCT 类型用于将多个字段组合成一个结构体，每个字段可以
- `STRUCT` 类型之间的转换取决于内部的类型之间是否能转换(名字不影响转换)，`STRUCT`类型不能转成其他类型。
- 字符串类型可以转换成`STRUCT`类型（通过解析的形式，解析失败返回 NULL）。
- `STRUCT`
类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为KEY列，无法作为分区分桶列。**
-- `STRUCT`类型的列不支持比较或者算数运算，**不支持`ORDER BY`和`GROUP BY`操作，不支持作为`JOIN
KEY`，不支持在`DELETE`语句中使用**。
+- `STRUCT`类型的列不支持比较或者算数运算，包括`IN`和`NOT IN`，**不支持`ORDER BY`和`GROUP
BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
- `STRUCT`类型的列不支持建立任何索引。
## 类型构造
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
index a82f58603a4..2bb5f6b7ea3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
@@ -15,4 +15,16 @@ IN 操作符测试一个值是否属于某个值列表或子查询中的成员
| 操作符 | 作用 | 示例
|
| ------ | ----------------------------------------------- |
--------------------------- |
| IN | 测试是否等于任意的成员。如果是，则返回 TRUE。 | `SELECT 1 IN (SELECT 2)` |
-| NOT IN | 测试是否不等于所有的成员。如果是，则返回 TRUE。 | `SELECT 1 NOT IN (3, 4, 5)` |
\ No newline at end of file
+| NOT IN | 测试是否不等于所有的成员。如果是，则返回 TRUE。 | `SELECT 1 NOT IN (3, 4, 5)` |
+
+## 类型限制
+
+`IN` 和 `NOT IN` 仅支持标量基本类型。`ARRAY`、`MAP` 和 `STRUCT` 等复杂类型，以及对象类型，不能作为左侧表达式或
`IN` 列表中的值。
+
+以下语句无效：
+
+```sql
+SELECT STRUCT(1, 2) IN (STRUCT(1, 2));
+SELECT [1, 2] IN ([1, 2]);
+SELECT MAP('a', 1) IN (MAP('a', 1));
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
index 95305a00117..ccafc9015c5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
@@ -26,6 +26,7 @@
-
`ARRAY<T>`类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为KEY列，无法作为分区分桶列**。
- `ARRAY<T>`类型的列**支持`ORDER BY`和`GROUP BY`操作**。
- 支持`ORDER BY`和`GROUP
BY`的T类型包括：`BOOLEAN,TINYINT,SMALLINT,INT,BIGINT,LARGEINT,FLOAT,DOUBLE,DECIMAL,DATE,DATETIME,TIMESTAMPTZ,CHAR,VARCHAR,STRING,IPTV4,IPV6`。
+- `ARRAY<T>`类型的列不支持`IN`或`NOT IN`操作。
- `ARRAY<T>`类型的列不支持作为 `JOIN KEY`，不支持在`DELETE`语句中使用。
## 常量构造
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
index fbac009dac1..5cd0a2fbbb8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
@@ -25,7 +25,7 @@
- 例如: `MAP<INT,INT>`可以转换为`MAP<BIGINT,BIGINT>`，因为`INT`和`BIGINT`可以转换。
- 字符串类型可以转换成`MAP<key_type, value_type>`类型（通过解析的形式，解析失败返回 NULL）。
- `MAP<key_type, value_type>`
类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为`Key`列，无法作为分区分桶列**。
-- `MAP<key_type, value_type>`类型的列不支持比较或者算数运算，**不支持`ORDER BY`和`GROUP
BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
+- `MAP<key_type, value_type>`类型的列不支持比较或者算数运算，包括`IN`和`NOT IN`，**不支持`ORDER
BY`和`GROUP BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
- `MAP<key_type, value_type>`类型的列不支持建立任何索引。
## 类型构造
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
index 230efac64af..3f6b6f346cd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
@@ -22,7 +22,7 @@ STRUCT 类型用于将多个字段组合成一个结构体，每个字段可以
- `STRUCT` 类型之间的转换取决于内部的类型之间是否能转换(名字不影响转换)，`STRUCT`类型不能转成其他类型。
- 字符串类型可以转换成`STRUCT`类型（通过解析的形式，解析失败返回 NULL）。
- `STRUCT`
类型在`AGGREGATE`表模型中只支持`REPLACE`和`REPLACE_IF_NOT_NULL`，**在任何表模型中都无法作为KEY列，无法作为分区分桶列。**
-- `STRUCT`类型的列不支持比较或者算数运算，**不支持`ORDER BY`和`GROUP BY`操作，不支持作为`JOIN
KEY`，不支持在`DELETE`语句中使用**。
+- `STRUCT`类型的列不支持比较或者算数运算，包括`IN`和`NOT IN`，**不支持`ORDER BY`和`GROUP
BY`操作，不支持作为`JOIN KEY`，不支持在`DELETE`语句中使用**。
- `STRUCT`类型的列不支持建立任何索引。
## 类型构造
diff --git
a/versioned_docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
b/versioned_docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
index 84ab00ef6a0..e30f93fe012 100644
---
a/versioned_docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
+++
b/versioned_docs/version-4.x/sql-manual/basic-element/operators/conditional-operators/in-operators.md
@@ -15,4 +15,16 @@ The IN operator tests whether a value is a member of a list
of values or a subqu
| Operator | Function | Example |
| ------- | ------------------------------------------------ |
------------------------------ |
| IN | Tests if it is equal to any member. Returns TRUE if so. | `SELECT 1
IN (SELECT 2)` |
-| NOT IN | Tests if it is not equal to all members. Returns TRUE if so. |
`SELECT 1 NOT IN (3, 4, 5)` |
\ No newline at end of file
+| NOT IN | Tests if it is not equal to all members. Returns TRUE if so. |
`SELECT 1 NOT IN (3, 4, 5)` |
+
+## Type Constraints
+
+`IN` and `NOT IN` support scalar primitive values only. Complex types such as
`ARRAY`, `MAP`, and `STRUCT`, as well as object types, cannot be used as the
left-hand expression or as values in the `IN` list.
+
+For example, the following statements are invalid:
+
+```sql
+SELECT STRUCT(1, 2) IN (STRUCT(1, 2));
+SELECT [1, 2] IN ([1, 2]);
+SELECT MAP('a', 1) IN (MAP('a', 1));
+```
diff --git
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
index c213730e092..d0cf93dbf99 100644
---
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
+++
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/ARRAY.md
@@ -26,6 +26,7 @@ The `ARRAY<T>` type is used to represent an ordered
collection of elements, wher
- In the `AGGREGATE` table model, `ARRAY<T>` type only supports `REPLACE` and
`REPLACE_IF_NOT_NULL`. **In any table model, it cannot be used as a KEY column,
nor as a partition or bucket column**.
- Columns of `ARRAY<T>` type **support `ORDER BY` and `GROUP BY` operations**.
- T types that support `ORDER BY` and `GROUP BY` include: `BOOLEAN, TINYINT,
SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME,
TIMESTAMPTZ, CHAR, VARCHAR, STRING, IPV4, IPV6`.
+- Columns of `ARRAY<T>` type do not support `IN` or `NOT IN` operations.
- Columns of `ARRAY<T>` type do not support being used as `JOIN KEY` and do
not support being used in `DELETE` statements.
## Constant Construction
diff --git
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
index f110dcd1307..e06373dcbc9 100644
---
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
+++
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/MAP.md
@@ -23,7 +23,7 @@
- For example: `MAP<INT, INT>` can be converted to `MAP<BIGINT, BIGINT>`
because `INT` and `BIGINT` can be converted.
- String types can be converted to `MAP<key_type, value_type>` (through
parsing, returning NULL if parsing fails).
- In the `AGGREGATE` table model, `MAP<key_type, value_type>` only supports
`REPLACE` and `REPLACE_IF_NOT_NULL`. **In any table model, it cannot be used as
a KEY column, nor as a partition or bucket column**.
-- Columns of type `MAP<key_type, value_type>` do not support comparison or
arithmetic operations, **do not support `ORDER BY` and `GROUP BY` operations,
cannot be used as `JOIN KEY`, and cannot be used in `DELETE` statements**.
+- Columns of type `MAP<key_type, value_type>` do not support comparison or
arithmetic operations, including `IN` and `NOT IN`, **do not support `ORDER BY`
and `GROUP BY` operations, cannot be used as `JOIN KEY`, and cannot be used in
`DELETE` statements**.
- Columns of type `MAP<key_type, value_type>` do not support creating any
indexes.
## Type Construction
diff --git
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
index b3f8b335e65..d6d79167d3d 100644
---
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
+++
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/semi-structured/STRUCT.md
@@ -31,7 +31,7 @@ The STRUCT type is used to combine multiple fields into a
single structure, wher
- In the `AGGREGATE` table model, `STRUCT` types only support `REPLACE` and
`REPLACE_IF_NOT_NULL`. **In any table model, they cannot be used as KEY
columns, nor as partition or bucket columns.**
-- Columns of `STRUCT` type do not support comparison or arithmetic operations,
**do not support `ORDER BY` and `GROUP BY` operations, cannot be used as `JOIN
KEY`, and cannot be used in `DELETE` statements.**
+- Columns of `STRUCT` type do not support comparison or arithmetic operations,
including `IN` and `NOT IN`, **do not support `ORDER BY` and `GROUP BY`
operations, cannot be used as `JOIN KEY`, and cannot be used in `DELETE`
statements.**
- Columns of `STRUCT` type do not support creating any indexes.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
