I highlighted all differences between the first and the other statements. The value "aha" is inside the second repetition of the field 'test::name'
Result of evaluation
Why won't the SQL statement sql02 return anything. Looking at statement sql03, it looks like only the last statement inside the brackets is being evaluated. Looks like a BUG to me.