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

U0100076: Functions cannot be used in GaussDB hierarchical queries

Description

Functions cannot be used in GaussDB hierarchical queries.

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_KEEP WHERE ID=4 START WITH NAME='A' CONNECT BY PRIOR ID=FATHERID AND PRIOR DBMS_RANDOM.VALUE(0,1) IS NOT NULL;

Suggestion

No solution is available. You are advised to refactor application code or avoid using functions in hierarchical queries.