Query of Query UNION doesn't distinct the resultset

Description

When unioning two result sets together, only a distinct list is supposed to be returned unless "union all" is used.

In Adobe CF, the code below returns 1 row, but in Lucee, it returns 2 rows.

TryCF link:
https://trycf.com/gist/14a9f55a03f2c56de7a2c8ac5bee0f6a/lucee5?theme=monokai

Status

Assignee

Michael Offner

Reporter

Brad Wood

Labels

None

Priority

New
Configure