Hi, I am trying to run H2 as a database in memory with Oracle compatibility, and I occur on case where I can't manage. I have script which contains Function base index and It doesn't work on H2, Documentation says that You can work around it by creating some kind of computing column and put index on it, but I would like to Oracle syntax work. There were some missmatch with Oracle na H2 with function but all of them I implement by my self just this use case I can't resolve.
What for such effort? I would like to run all my oracle script during execution of my tests on in memory database for extra sure that scripts are correct. I don't want auto generate schema(hibernate auto generation schema feature), and I don't want to have 2 types of script(one for Oracle one for H2). Does someone occur similar problem? PS> Sorry for my cranky english -- 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/groups/opt_out.
