The Oracle mode of OceanBase Database imposes limitations on expressions of function-based indexes. This topic lists the system functions that are not supported for function-based indexes.
System functions not related to users
System functions not related to users are all prohibited in function-based indexes.
Other system functions
The following system functions are prohibited in function-based indexes.
| REGEXP_REPLACE | CONNECT_BY_PATH | SCN_TO_TIMESTAMP | CURRENT_TIMESTAMP |
| CURRENT_DATE | ROWNUM | HOST_IP | USERENV |
| REGEXP_LIKE | RPC_PORT | DBTIMEZONE | IS_SERVING_TENANT |
| UID | LAST_TRACE_ID | SYSTIMESTAMP | SYSDATE |
| SESSIONTIMEZONE | LOCALTIMESTAMP | SYS_GUID | OB_VERSION |
| AT TIME ZONE | SYS_CONTEXT | AT LOCAL | USER |
| VALUES | TIMESTAMP_TO_SCN | ROWID_TO_CHAR | LNNVL |
| DBTIMEZONE | DECODE | CARDINALITY | DEFAULT |
| ROWIDIDTONCHAR | REGEXP_INSTR | REGEXP_COUNT | REGEXP_SUBSTR |
| DUMP | - | - | - |