Database Error Messages

Release
toggle
  • 23ai
  • 21c
Updated
Jun 24, 2024

OCI-03811

Filtering shard query results based on the CURRENT_SHARD_KEY or CURRENT_PSET_KEY function is not supported with full outer joins.

Cause

An attempt was made to call either the CURRENT_SHARD_KEY or CURRENT_PSET_KEY function to filter results of a sharded query with full outer joins.


Action

Disable filtering shard query results for queries with full outer joins.