Forgot to say that it's the union that is causing the problem. If there is just one select instead of the union (remove the union and extra select) there is no syntax error.
On Jan 26, 1:58 pm, SuperSpinner <[email protected]> wrote: > create table foo (bar int); > select count(*) from (select bar from foo where bar in ( select bar > from foo union select bar from foo ) ) a; > > This is legal SQL and should succeed. The inner query > select bar from foo where bar in ( select bar from foo union select > bar from foo ) > works just fine. > > I think this is a bug in 1.1 and 1.2 > > Thanks > Randy -- 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.
