Re: [h2] Re: Corruption on select distinct with join

2013-06-14 Thread Andrew Helgeson
Hi Noel, Thanks for looking into it more. At least I wasn't completely crazy :) On Friday, June 14, 2013 7:13:06 AM UTC-5, Noel Grandin wrote: > > > On 2013-06-13 19:58, Andrew Helgeson wrote: > > > > Thanks for your help however I'm still running into this problem with > > the latest code. I

Re: [h2] Re: Corruption on select distinct with join

2013-06-14 Thread Noel Grandin
On 2013-06-13 19:58, Andrew Helgeson wrote: Thanks for your help however I'm still running into this problem with the latest code. I built a jar from the svn repo at r4849 and it's still occurring with the same stack trace. Hi OK, I can reproduce this now. It only seems to happen about 1

[h2] Un-DELETE inside a trigger?

2013-06-14 Thread Grant Beaty
I use triggers to modify some rows as they are inserted or updated, but sometimes I need to roll-back a DELETE. Is this possible to do within a trigger, or do I need to use the provided connection to re-INSERT the row? Thanks, Grant -- You received this message because you are subscribed to th

Re: [h2] Limiting database size on disk

2013-06-14 Thread Noel Grandin
On 2013-06-14 09:02, Ryan How wrote: But it does re-use space. So if you delete data, then insert new data, the database won't grow, it will overwrite the deleted data. Definitely. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] Limiting database size on disk

2013-06-14 Thread Ryan How
But it does re-use space. So if you delete data, then insert new data, the database won't grow, it will overwrite the deleted data. Please correct me if I am wrong. On 14/06/2013 2:33 PM, Noel Grandin wrote: You can use DISK_SPACE_USED to get the approx amount of space used by a table http://