R*Tree table constraints

(1) By anonymous on 2021-03-25 11:21:25 [link] [source]

Table constraints seems to be disallowed for R*Tree tables:

sqlite> create virtual table test using rtree(id integer primary key, x1, x2, y1, y2, check(x1 < x2));
Error: near "REAL": syntax error

Column constraints are accepted, but does not seem to have any effect:

sqlite> create virtual table test using rtree(id integer primary key, x1, x2 check (x2 > x1), y1, y2 (check y2 > y1));
sqlite> insert into test values(1, 1, 1, 1, 1);
sqlite>

(2) By Richard Hipp (drh) on 2021-03-25 13:02:17 in reply to 1 [source]

Yes, you are correct on both counts.

(3) By anonymous on 2021-03-25 13:12:21 in reply to 2 [link] [source]

Thanks! Feature or bug? From the tone of your reply, I'd guess the former :)

(4) By Keith Medcalf (kmedcalf) on 2021-03-25 13:18:10 in reply to 3 [link] [source]

I would have replied "Working as Designed and Documented".

See https://sqlite.org/rtree.html section 3.1.1

(5) By anonymous on 2021-03-25 14:03:58 in reply to 4 [link] [source]

Got it, thanks.