cte_max_recursion_depth sets the maximum recursion depth of common table expressions (CTEs). The server aborts any operation that exceeds this CTE value.
Note
This variable is introduced since OceanBase Database V3.2.4 BP3 and is supported only in MySQL mode.
| Attribute | Description |
|---|---|
| Type | UInt |
| Default value | 1000 |
| Value range | [0, 4294967295] |
| Applicable scope |
|
| Involved in serialization | No |