[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

Update (just that this ) won't happen: The issue could be resolved, the pull request https://github.com/h2database/h2database/pull/391/

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

I have created a pull request on this issue: https://github.com/h2database/h2database/pull/391/ I would appreciate some feedback on this. Basically, the whole isNull() funtionality in *SpatialDataType *is not working at all. Maybe Null Geometries can be added (and retrieved with hacks) to an

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

Any idea anyone? The example script I provided makes it quite easy to reproduce the error... -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

..forgot to mention, the *get* function takes place in MVRTreeMap.java. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com.

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

Hi, Nicolas, thanks for the remark, and sorry for not providing an example. I do have the latest version so the handling of null geometries is up to date. One test function that has been added in the pull request you mentioned only checks for a small table (size one I believe). However, in

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

Hi, A Pull request has been merged about the handling of null geometries: https://github.com/h2database/h2database/pull/267/files You don't provide any sql sample of the query and the expected result. So I don't understand your question. Regards, Le mardi 18 octobre 2016 08:40:35 UTC+2, Sven

[h2] Re: Entries in a table containing Geometries cannot be found when the Geometry is empty ( Row not found when trying to delete from index )

I forgot another way to find such keys, maybe this is even safer. Couldn't the *Page *be passed down to the *contains *function and perform a binary search on the key in question? public boolean contains(Page p, int index, Object key) { SpatialKey a = (SpatialKey) p.getKey(index); SpatialKey b