Re: [h2] Re: Insert with multi column constraint issue

2015-03-05 Thread Noel Grandin
On Thu, Mar 5, 2015 at 5:57 PM, Mike Goodwin wrote: > Ok, I can see that the constraint is specified incorrectly (in the wrong > order). > > It really had to be something like that. Still, should it be possible to > create a constraint with mismatched columns like that? > You used the NOCHECK key

[h2] Re: Insert with multi column constraint issue

2015-03-05 Thread Mike Goodwin
Ok, I can see that the constraint is specified incorrectly (in the wrong order). It really had to be something like that. Still, should it be possible to create a constraint with mismatched columns like that? Sorry! Mike On Thu, Mar 5, 2015 at 3:35 PM, Mike Goodwin wrote: > Hi, > > I am ha

[h2] Insert with multi column constraint issue

2015-03-05 Thread Mike Goodwin
Hi, I am having an issue with a particular insert not working. I have made a simplified test case below. I've tried on 1.4.186 and 1.3.171 where I originally had the issue. Remove the constraint and there is no error thrown. DROP ALL OBJECTS; SET DB_CLOSE_DELAY -1; CREATE USER IF NOT EXISTS SA S

[h2] MVStore - Statistics

2015-03-05 Thread
Hi Thomas and Noel, What do you think to include some internal informations of current state of MVStore. I think that such informations can be useful in some situations (tunning, perfomance improvements in the code and so on). As the MVStore is still experimental, maybe some additional information

Re: [h2] MVStore.cacheChunkRef memory usage

2015-03-05 Thread
Hi Thomas, Ok! Regards, Fred 2015-03-05 4:53 GMT-03:00 Thomas Mueller : > Hi, > > I have a new patch for the LIRS cache: > > Index: src/main/org/h2/mvstore/cache/CacheLongKeyLIRS.java > === > --- src/main/org/h2/mvstore/cache/Cach

Re: [h2] No database in the Console

2015-03-05 Thread Max Telfer
Hi again I get the same result with any browser - Chrome, IE, Firefox. This used to work. I open the browser by double clicking the h2-4-186,jar file. The console window opens with the entries: The Console fields are: Generic H2 (Server) org.h2.Driver jdbc:h2:c:/ProgramData/companyname/dbshift