My Oracle Support Banner

XMLELEMENT with XMLAGG Aggregate Operator Returns Single Row Instead of "No rows selected" with an Always False Predicate (Doc ID 1624193.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

When using XMLelement/XMLagg functions in a query in conjunction with an inline view, the resulting query returns a row even when the inline view would not have returned any rows if executed independently.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.