Incorrect HTTP status code returned for spatial join request for WFS

[Kate-Lyndegaard]

When validating this WFS in the OGC Team engine validator, it fails for the Spatial joins → join With Intersects test (and therefore also in the INSPIRE validator).

This post request does not return a valid HTTP code:
<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs/2.0" count="10" service="WFS" version="2.0.0"> <wfs:Query xmlns:ns55="http://inspire.ec.europa.eu/schemas/elu/4.0" typeNames="ns55:ExistingLandUseObject ns55:ExistingLandUseDataSet"> <Filter xmlns="http://www.opengis.net/fes/2.0"> <Intersects> <ValueReference>ns55:ExistingLandUseObject/ns55:geometry</ValueReference> <ValueReference>ns55:ExistingLandUseDataSet/ns55:extent</ValueReference> </Intersects> </Filter> </wfs:Query> </wfs:GetFeature>

The post request returns:

<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows/1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://schemas.opengis.net/ows/1.1.0/owsExceptionReport.xsd" version="2.0.0"> <ows:Exception exceptionCode="NoApplicableCode"> <ows:ExceptionText>Join queries between multiple feature types in blob mode are not by SQLFeatureStore (yet).</ows:ExceptionText> </ows:Exception> </ows:ExceptionReport>

Do you know if there any cases where this does work (i.e. if not using Blob mode)?

[tfr42]

@Kate-Lyndegaard Did you tested it with a relational mapping SQLFeatureStore? For this configuration I would expect the spatial joins to work.