Skip to content

30-Name & Limits

Name length boundary
1. Database name length boundary check
2. Table name length boundary check
3. Column name length boundary check
4. Tag name length boundary check
5. User name length boundary check
6. Password length boundary check
7. SQL length boundary check
8. Row/Column/Tag max length check
9. Full name length check

SQL length boundary
1. Test normal insert sql with 10MB length
2. Test 10MB insert sql with 10MB length
3. Test 64MB insert sql with 64MB length
4. Test out of boundary value

Name table
1. Database name validation
2. Table name validation

Name database
1. Validates naming conventions and boundary checks for databases and tables.
2. Verifies both valid and invalid identifiers across operations like CREATE, USE, DROP, and DESCRIBE, including handling of quoted identifiers and case sensitivity.
3. Ensures compliance with naming rules, which allow only English letters, numbers, and underscores, and prohibit names starting with numbers or containing spaces.