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

U0100073: GaussDB does not have a function equivalent to SYS_OP_MAP_NONNULL

Description

GaussDB does not have a function equivalent to SYS_OP_MAP_NONNULL of Oracle. Generally, users perform operations on index-organized tables or indexes. SYS_OP_MAP_NONNULL is a function in a package only for internal use.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB versions supported by UGO

Syntax Example

SELECT * FROM TEST_TBL WHERE SYS_OP_MAP_NONNULL(col1)=SYS_OP_MAP_NONNULL(col2);

Suggestion

No solution is available. You are advised to refactor application code. Although SYS_OP_MAP_NONNULL is an internal function of the Oracle database, its usage and implementation details are not disclosed. To ensure there is no empty field in tables, you are advised to use database-level constraints instead of internal functions.