Trying to better understand how implicit joins work, I tried this: select * from table(a int = (1,2,3)), table(b int = (3,4,5))
which gives different results than select * from (select * from table(a int = (1,2,3))), (select * from table(b int = (3,4,5))) Not affecting anything, but it was curious. The first case has enough rows for a cross join, but the columns are all A. Explicitly cross joining also returns only A. select * from table(a int = (1,2,3)) cross join table(b int = (3,4,5)) Is this expected? The second example returns an actual cross join. v 1.3.175 -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
