SQLite Forum

geopoly_json rounding effect
Login
```
sqlite> select geopoly_within(p1._shape,p2._shape) from poly p1, poly p2 where p1.rowid=1764 and p2.rowid=158;
0
sqlite> select geopoly_within(geopoly_json(p1._shape),geopoly_json(p2._shape)) from poly p1, poly p2 where p1.rowid=1764 and p2.rowid=158;
1
sqlite> .sch poly
CREATE VIRTUAL TABLE poly using geopoly()
/* poly(_shape) */;
```

The _shape's here are pretty long. I can try to reduce them to be usable as a bug report, but first I'd like to know - should I have expected such effect?