On Sun, May 11, 2014 at 6:51 AM, Vishwa <[email protected]> wrote: > > > 1. Link table issue > When I issue the following query internally translated invalid where > condition > Link table with where condition > Original query: insert into mem_table select * from abc_link where number > in(421404,421196,421314,630606,321351,421208,200812,671085,230884,321337) > translated as below which is invalid > Executed query: select * from abcview T WHERE NUMBER>=200812 AND > NUMBER<=200812 > I cannot see how we could possibly be modifiying the query like that. We don't do that kind of optimisation. How are you seeing the translated query?
> 2. I cannot start/connect in memory database if want to disable MV Store > using MV_STORE=FALSE > DB URL: > jdbc:h2:mem:ingestion;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOG=0;UNDO_LOG=0;MODE=MYSQL;MVCC=0;MVCC=FALSE;MV_STORE=FALSE > If i just use MVCC=FALSE; still MVTable get created and throws some > exception. > What does the exception look like? > 3. I get random error General errors Remove the LOG=0 and UNDO_LOG=0 stuff from your URL and try again. We are not interested in helping people who self-inflict damage by using options clearly marked as dangerous. -- 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.
