Hey! I have a table into which i insert records with polygonal geometry. And the problem is that some records do not show in the resultset when using the spatial query (&& WKT_GEOM). I checked manually that the geometry of the inserted features overlaps (actually the are completely within) the query geometry. If i drop the spatial index and recreate it, i get the missing records!
I was not able to produce a working example on a simple table (my table has about 30 columns). But this is what i do: First i insert the record with null geometry, then i update the geometry column with "normal" geometry. So i guess the problem lies in updating the spatial index? Any ideas? Also, i'm using the 191 version. Thanks! -- 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.
