In my investigation I got “expected” as does what I wanted it to do then 
Yes, if it threw an error that would be better even.
It not something we would usually write, I just got trigger happy fixing a bug with a missing ORDER BY we had which became apparent on Lucee 6 and the included perf. improvements (Lucee 6 - Query of Queries Loses Order From Source Query - #2 by Gavin_Baumanis).
As always @bdw429s, thanks for the detailed explanation and fix!