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 
where state='CA')

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 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to