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

U0400053: GaussDB (M-compatible mode) does not support this data type in CAST or CONVERT

Description

GaussDB (M-compatible mode) does not support the YEAR, ARRAY, and REAL data types in the CAST or CONVERT system function.

Database Type and Version

  • Source database type and version: MySQL 8.0
  • Target database type and version: GaussDB (M-compatible mode)
Syntax Example
SELECT CAST(CUSTINFO -> '$.ZIPCODE' AS UNSIGNED ARRAY) FROM CUSTOMERS1;

Suggestion

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