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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot