09-limit.md 4.2 KB
Newer Older
1 2 3 4 5 6
---
title: Limits & Restrictions
---

## Naming Rules

7 8
1. Only characters from the English alphabet, digits and underscore are allowed
2. Names cannot start with a digit
S
Sean Ely 已提交
9
3. Case insensitive without escape character "\`"
10 11 12 13 14 15 16 17 18
4. Identifier with escape character "\`"
   To support more flexible table or column names, a new escape character "\`" is introduced. For more details please refer to [escape](/taos-sql/escape).

## Password Rule

The legal character set is `[a-zA-Z0-9!?$%^&*()_–+={[}]:;@~#|<,>.?/]`.

## General Limits

19 20 21 22
- Maximum length of database name is 32 bytes.
- Maximum length of table name is 192 bytes, excluding the database name prefix and the separator.
- Maximum length of each data row is 48K bytes since version 2.1.7.0 , before which the limit was 16K bytes. Please note that the upper limit includes the extra 2 bytes consumed by each column of BINARY/NCHAR type.
- Maximum length of column name is 64.
23 24 25
- Maximum number of columns is 4096. There must be at least 2 columns, and the first column must be timestamp.
- Maximum length of tag name is 64.
- Maximum number of tags is 128. There must be at least 1 tag. The total length of tag values should not exceed 16K bytes.
26 27 28
- Maximum length of singe SQL statement is 1048576, i.e. 1 MB. It can be configured in the parameter `maxSQLLength` in the client side, the applicable range is [65480, 1048576].
- At most 4096 columns (or 1024 prior to 2.1.7.0) can be returned by `SELECT`. Functions in the query statement constitute columns. An error is returned if the limit is exceeded.
- Maximum numbers of databases, STables, tables are dependent only on the system resources.
S
Sean Ely 已提交
29
- Maximum of database name is 32 bytes, and it can't include "." or special characters.
30 31 32 33 34 35 36
- Maximum number of replicas for a database is 3.
- Maximum length of user name is 23 bytes.
- Maximum length of password is 15 bytes.
- Maximum number of rows depends only on the storage space.
- Maximum number of tables depends only on the number of nodes.
- Maximum number of databases depends only on the number of nodes.
- Maximum number of vnodes for a single database is 64.
37 38 39

## Restrictions of `GROUP BY`

40
`GROUP BY` can be performed on tags and `TBNAME`. It can be performed on data columns too, with the only restriction being it can only be performed on one data column and the number of unique values in that column is lower than 100,000. Please note that `GROUP BY` cannot be performed on float or double types.
41 42 43

## Restrictions of `IS NOT NULL`

44
`IS NOT NULL` can be used on any data type of columns. The non-empty string evaluation expression, i.e. `< > ""` can only be used on non-numeric data types.
45 46 47

## Restrictions of `ORDER BY`

S
Sean Ely 已提交
48
- Only one `order by` is allowed for normal table and subtable.
49
- At most two `order by` are allowed for STable, and the second one must be `ts`.
50
- `order by tag` must be used with `group by tag` on same tag. This rule is also applicable to `tbname`.
51 52 53 54 55 56 57 58
- `order by column` must be used with `group by column` or `top/bottom` on same column. This rule is applicable to table and STable.
- `order by ts` is applicable to table and STable.
- If `order by ts` is used with `group by`, the result set is sorted using `ts` in each group.

## Restrictions of Table/Column Names

### Name Restrictions of Table/Column

59
The name of a table or column can only be composed of ASCII characters, digits and underscore and it cannot start with a digit. The maximum length is 192 bytes. Names are case insensitive. The name mentioned in this rule doesn't include the database name prefix and the separator.
60 61 62

### Name Restrictions After Escaping

S
Sean Ely 已提交
63
To support more flexible table or column names, new escape character "\`" is introduced in TDengine to avoid the conflict between table name and keywords and break the above restrictions for table names. The escape character is not counted in the length of table name.
64 65 66 67 68 69 70 71 72 73 74 75 76 77

With escaping, the string inside escape characters are case sensitive, i.e. will not be converted to lower case internally.

For example:
\`aBc\` and \`abc\` are different table or column names, but "abc" and "aBc" are same names because internally they are all "abc".

:::note
The characters inside escape characters must be printable characters.

:::

### Applicable Versions

Escape character "\`" is available from version 2.3.0.1.