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
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
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