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 a écrit : > > 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 = (SpatialKey) key; > > if (a.isNull() || b.isNull()) { > return p.binarySearch(a) >= 0; // <------------ > } > for (int i = 0; i < dimensions; i++) { > if (a.min(i) > b.min(i) || a.max(i) < b.max(i)) { > return false; > } > } > return true; > } > > > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
