Hi all, I am using H2 for in memory testing. We got couple of test passing but executing against oracle db(version 11g) , got `*ORA-00936 missing expression*`. We are using a customer SQL builder(a DSL) and it was wrongly building some query similar to this:
select * from some_table t1 where t1.uuid = (select t2.uuid from another_table t2 where t2.state in ()); The issue is with t2.state in () This works with H2, but not with Oracle. Now, I don't want to say, its a bug since oracle doesn't support it, but allowing such a query doesn't make much sense to me. This post also aims to help people searching find a result, who would get hit by this. Would you consider this a bug or you think its ok like this? Br, Ayan -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
