I'm not sure how to interpret the manual regarding the use of tuples in semi-joins. The following syntax is valid SQL in some databases:
-- Oracle select 1 from dual where (1, 2) in (select 1, 2 from dual) -- Postgres select 1 where (1, 2) in (select 1, 2) H2 doesn't seem to support either statement. Does H2 support subqueries in IN-predicates, when the left-hand side is a tuple? Cheers Lukas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/-7KHPPCludkJ. 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.
