Re: [h2] TRANSACTION_READ_UNCOMMITTED Transaction isolation in H2

2015-02-27 Thread Ryan How
I think with the MVStore it only works with READ_COMMITTED. Other isolation levels don't work. If you use the page store it should work (or the latest stable version). On 28/02/2015 10:25 AM, Sachin Patil wrote: Hello there, I am trying use H2 database(1.4.185) in junit environment and

[h2] TRANSACTION_READ_UNCOMMITTED Transaction isolation in H2

2015-02-27 Thread Sachin Patil
Hello there, I am trying use H2 database(1.4.185) in junit environment and found out that TRANSACTION_READ_UNCOMMITTED is not working as expected for me. I have created junit test case gist which reproduces this, https://gist.github.com/sacdroid/c6e29a4e4f84916fafec Can you

Re: [h2] Performance question - multi column query

2015-02-27 Thread FredDaniPandoraAquiles
Hi, I think for range conditions would be better estimate the cost on the basis of histograms. However, at this moment the H2 doesn't make use of histograms to estimate its costs. Evaluating postgres with your test-case, I verified that for expressions like 'time VALUE AND timeend VALUE', the

Re: [h2] Operator precedence

2015-02-27 Thread Thomas Mueller
Hi, This should be available in the SQL grammar railroads: http://h2database.com/html/grammar.html#operand On Wed, Feb 25, 2015 at 10:07 PM, Timo Westkämper timo.westkam...@gmail.com wrote: Hi. Could someone point me to the specification of operator precedence in H2? Thanks, Timo --

Re: [h2] MVStore.cacheChunkRef memory usage

2015-02-27 Thread Thomas Mueller
Hi, OK, that sounds like a bug. Do you have a simple test case for this (a patch to TestCacheLongKeyLIRS or TestCacheLIRS? Regards, Thomas On Fri, Feb 20, 2015 at 12:39 PM, FredDaniPandoraAquiles zepf...@gmail.com wrote: Hi, I expressed myself incorrectly in the previous post. The cold

[h2] Fail to stop database while executing 'BACKUP TO' query

2015-02-27 Thread Ivan Pavlukhin
Hi, We are using 1.3.163 version of h2db as an embedded db in a single thread mode. I have encounter a problem that it is impossible to stop application while 'BACKUP TO' sql statement is in execution. It is a big problem for our project. Our clients databases can be around 1GB size and