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

U0400033: GaussDB does not support the system function

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

For some system functions that are not supported by GaussDB (B-compatible mode), UGO allows you to replace them with custom functions.

For example, the SQRT function is supported by GaussDB, but the method of handling an abnormal input is different from that of MySQL. If the following statement returns NULL in MySQL, this error is reported for GaussDB.

select sqrt(-2) ;

Suggestion

Modify UGO user-defined function conversion. You can download source code of the converted custom function on the Downloads > UGO-defined Functions page.