When a SELECT is used as a sub-query of an IN, is the sub-query only
executed once? Consider the following made up query that finds all staff
members who are in the state of California who are also a student majoring
in Computer Science.
select * from students where major='CSC' and id IN (select id from staff
Does H2 first execute the sub-query, and the the outer one? Or does it
execute the sub-query at every row match from the outer query? I am using
version 1.3.176 with page store (if that matters).
You received this message because you are subscribed to the Google Groups "H2
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to firstname.lastname@example.org.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.