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

U0400047: GaussDB (M-compatible mode) does not support triggers

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: GaussDB (M-compatible mode)

Syntax Example

GaussDB (M-compatible mode) does not support triggers, for example:

CREATE TRIGGER before_user_delete
BEFORE DELETE ON users
FOR EACH ROW
BEGIN
    INSERT INTO user_logs (user_id, action)
    VALUES (OLD.id, 'DELETE');
END;

UGO retains the input without any conversion and displays an error message.

Suggestion

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