Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Common Conversion Error Codes/ U0000001: GaussDB Distributed does not support generated columns in tables
Updated on 2025-06-07 GMT+08:00

U0000001: GaussDB Distributed does not support generated columns in tables

Description

Database Type and Version

  • Source database type and version: all types of the source database storing tables with generated columns
  • Target database type and version: GaussDB Distributed

Syntax Example

This error is reported because UGO does not convert generated columns by default.

Generated columns cannot be created in tables on a distributed GaussDB database, for example:

CREATE TABLE person (
    id INT PRIMARY KEY,
    first_name VARCHAR(64),
    last_name VARCHAR(64),
    full_name VARCHAR(128) GENERATED ALWAYS AS (concat(first_name, ' ', last_name))
);

Suggestion

Modify Support for virtualColumn.