[h2] Hash index broken?

2013-08-08 Thread Steve McLeod
Hi Thomas and all, Below is a reproducible test case showing that hash index doesn't reliably work. This problem exists in H2 1.3.173. Let me know if you need further information. Regards, Steve -- reproducible test case that demonstrates that hash indexes are broken with memory tables -- c

Re: [h2] Hash index broken?

2013-08-08 Thread Noel Grandin
Thanks, fix committed. The problem as actually not to do with memory tables, it had to do with different cardinal types in the underlying table vs the query column. In this case, the underlying column was a LONG, but the query key was an INT, which led to incorrect results. On 2013-08-08 12:3

Re: [h2] Hash index broken?

2013-08-09 Thread Steve McLeod
Thanks Noel. On Thursday, 8 August 2013 13:44:02 UTC+2, Noel Grandin wrote: > > Thanks, fix committed. > > The problem as actually not to do with memory tables, it had to do with > different cardinal types in the underlying table vs the query column. > In this case, the underlying column was a