ated later on did not work correctly if there were over 5000 rows in the
> table.". This is fixed with version 1.4.179. But you will need to re-create
> the database I'm afraid (via export to SQL script for example).
>
> Regards,
> Thomas
>
> On Thursday, June 19, 2014
I removed the FK contraint and hence the index CONSTRAINT_2_INDEX_2 - and
that seems to have fixed the issue.
It would be good to know why that error occured in the first place tho.
On Wednesday, 18 June 2014 10:42:12 UTC+1, Mahen Perera wrote:
> Hi,
> I am using h2 version 1.4.178,
>
Hi,
I am using h2 version 1.4.178,
and get below error from the application which uses H2:
Row not found when trying to delete from index
"PUBLIC.CONSTRAINT_2_INDEX_2: 12273"; SQL statement:
*delete from XXX WHERE A = ? and B in ( NULL , 'a' ) and C=3*[90112-178]
when trying to run the sa