Just tried on MySql and Derby, they both behave the same, so it appears it is the standard behaviour, though it still seems to me that the sub-select (SELECT T1 FROM test2 where ID=3) ought to fail with a "no such column" error.
Out of interest, what's the logic behind the behavior, and why does the query return three rows? What does the sub-select actually return to the outer select? Cheers, Ian. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
