Descriptionβ
Each database object, such as tables, columns, and indexes, has a name. In SQL statements, these names are referred to as object identifiers. Identifiers can be quoted or unquoted. If an identifier contains special characters or reserved keywords, it must be quoted with backticks (`) each time it is referenced. For more details on reserved keywords, please refer to the Reserved Keywords section.
Object Identifier Restrictionsβ
In Doris, object identifiers can be controlled by the variable enable_unicode_name_support to determine whether Unicode characters are supported. When Unicode character support is enabled, identifiers can use any language characters in Unicode. However, punctuation marks and other characters are not allowed.
In Doris, different objects have different restrictions on identifiers, and the specific restrictions for different objects are listed below.
Table Namesβ
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[a-zA-Z][a-zA-Z0-9-_]*$ |
| Enabled Unicode Mode | ^[a-zA-Z\\p{L}][a-zA-Z0-9-_\\p{L}]*$ |
Column Namesβ
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[.a-zA-Z0-9_+-/?@#$%^&*\"\\s,:]{1,256}$ |
| Enabled Unicode Mode | ^[.a-zA-Z0-9_+-/?@#$%^&*\"\\s,:\\p{L}]{1,256}$ |
OUTFILE Namesβ
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[_a-zA-Z][a-zA-Z0-9-_]{0,63}$ |
| Enabled Unicode Mode | ^[_a-zA-Z\\p{L}][a-zA-Z0-9-_\\p{L}]{0,63}$ |
User Namesβ
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[a-zA-Z][a-zA-Z0-9.-_]*$ |
| Enabled Unicode Mode | ^[a-zA-Z\\p{L}][a-zA-Z0-9.-_\\p{L}]*$ |
LABEL Namesβ
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[-_A-Za-z0-9:]{1,N}$, where N is determined by the label_regex_length configuration in FE, with a default value of 128. |
| Enabled Unicode Mode | ^[-_A-Za-z0-9:\\p{L}]{1,N}$, where N is determined by the label_regex_length configuration in FE, with a default value of 128. |
| Mode | Identifier Restrictions |
|---|
| Closed Unicode Mode | ^[a-zA-Z][a-zA-Z0-9-_]{0,63}$ |
| Enabled Unicode Mode | ^[a-zA-Z\\p{L}][a-zA-Z0-9-_\\p{L}]{0,63}$ |
