Updated on 2025-06-07 GMT+08:00

U0400043: GaussDB does not support ALTER INDEX VISIBLE

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: all GaussDB versions

Syntax Example

The Alter INDEX VISIBLE statement of MySQL can make indexes visible or invisible. This error is reported because GaussDB does not support this syntax, for example:

ALTER TABLE test_check ALTER INDEX i1 VISIBLE;

Suggestion

No solution is available. You are advised to refactor application code.