SQLite Forum

geopoly_within doc bug
Login

geopoly_within doc bug

(1) By Boris (boris.gontar) on 2020-04-18 19:40:34 [link] [source]

The documentation states that "geopoly_within(P1,P2) function returns a non-zero integer if P2 is completely contained within P1". In fact it is vice-versa:

sqlite> select geopoly_within('[[0,0],[3,0],[3,3],[0,3],[0,0]]',
   ...> '[[1,1],[2,1],[2,2],[1,2],[1,1]]');
0
sqlite> select geopoly_within('[[1,1],[2,1],[2,2],[1,2],[1,1]]',
   ...> '[[0,0],[3,0],[3,3],[0,3],[0,0]]');
1
sqlite> select sqlite_version();
3.31.1

(2) By Richard Hipp (drh) on 2020-04-18 20:07:06 in reply to 1 [source]

Thanks for the report. Documentation bug fixed by docsrc check-in c3705ed80b01f279. Revised documentation uploaded.