fixed in 5.4.3.12-SNAPSHOT
I have enabled the looser backwards compat mode in hsqldb to do less strict type checks, basically allowing cfml style casting so the string matches the number coming back from the sub select
details in ticket [LDEV-4695] - Lucee