When creating a normal index, the following validations are applied:
- Maximum length of 48 characters
- No special characters allowed
- Spaces are not allowed
- Only underscore (_) is permitted
However, when restoring an index from a backup, these validations are not applied. Because of this, indexes can be restored with names that do not follow the naming rules.
For example:
- backup@#$123_ (contains special characters)
- backup_ 1M_int16d_m16_efcon128_2 (contains a space)
- 123456789012345678901234567890123456789012345678901234567890 (exceeds the 48-character limit)
These indexes get created during the restore process, but indexes with spaces or special characters in their names (like backup@#$123_ and backup_ 1M_int16d_m16_efcon128_2) cannot be accessed afterward.
When creating a normal index, the following validations are applied:
However, when restoring an index from a backup, these validations are not applied. Because of this, indexes can be restored with names that do not follow the naming rules.
For example:
These indexes get created during the restore process, but indexes with spaces or special characters in their names (like backup@#$123_ and backup_ 1M_int16d_m16_efcon128_2) cannot be accessed afterward.