Hi, Could you post a complete, reproducible, simple test case please, if possible just using SQL statements (a SQL script)?
Regards, Thomas On Mon, Apr 25, 2016 at 4:37 PM, Blaž Repnik <[email protected]> wrote: > Another thing, these records don't show up only when using the spatial > query (or a mixture of spatial and attribute). If i use only the attribute > query, i get all the rows. > > > > Dne ponedeljek, 25. april 2016 16.35.11 UTC+2 je oseba Blaž Repnik > napisala: > >> 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. > -- 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.
