Hello again,
Thanks very much for your message. So you're right; testing again, I'm now
consistently seeing the general form you described:
> ... WHERE (a in (v1, v2, v3) AND a IS NOT NULL)
Perhaps when I was still seeing the big chains of OR'd conditions I was looking
at some old logs by acci
Hi,
CQL does not have any relationship with SQL, other than a similar syntax,
what happens is that it gets
parsed into an in-memory representation that matches 1-1 the OGC Filter
Encoding specification.
If you check it, you'll find it has no notion of a IN operator, so the
expression is turned into
Hi, all.
I'm writing because of a behavior I've found with Geoserver 2.16's WFS+CQL/ECQL
and Postgres 9.6.x. It also appears to affect Geoserver back to at least
version 2.11.x.
ECQL's IN-operator -- at least when employed against (materialized) views --
seems to perform extra IS NOT NULL chec