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

U0400054: GaussDB does not support invisible columns

Description

GaussDB (M-compatible mode) does not support invisible columns.

Database Type and Version

  • Source database type and version: MySQL 8.0
  • Target database type and version: GaussDB (M-compatible mode)
Syntax Example
CREATE TABLE `invisible_pk_table` (
    `my_row_id` bigint unsigned NOT NULL INVISIBLE,
    `name` varchar(50) DEFAULT NULL,
    `age` int DEFAULT NULL,
    PRIMARY KEY (`my_row_id`)
);

Suggestion

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