Hi everyone,
I noticed that indexes that use nested BETWEEN SYMMETRIC operators
quickly exceed some limit, which is indicated by errors such as
"ERROR: row is too big: size 8440, maximum size 8160". For example,
consider the following (contrived) index:
CREATE TABLE t0(c0 TEXT);
CREATE INDEX i0 ON t0(c0) WHERE ((FALSE BETWEEN SYMMETRIC TRUE AND
(t0.c0 || t0.c0 IN (t0.c0, t0.c0, '1', t0.c0 || t0.c0, t0.c0 || t0.c0
|| t0.c0))) BETWEEN SYMMETRIC TRUE AND TRUE) BETWEEN SYMMETRIC TRUE
AND TRUE; -- ERROR: row is too big: size 8440, maximum size 8160
Is this an expected limitation?
Best,
Manuel