MySQL error processing ogc:Filter with ogc:And clause

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.6.3
  • Fix Version/s: 1.6.5
  • Component/s: None
  • Labels:
    None
  • Environment:
    Tomcat on Linux deployed from war file with MySQL extension (MySQL is not listed in components list)

Description

PropertyIsEqualTo filter works, BBOX filter works but when combined using an ogc:And clause the query processes successfully but returns no results.

See Nabble forum thread for details.
http://www.nabble.com/ogc-filter-error-in-1.6.3-%28from-1.5.2%29-to16627738.html

Links to demonstrate the error can be found here:
http://www.nabble.com/Re%3A-ogc-filter-error-in-1.6.3-%28from-1.5.2%29-p16676278.html

MySQL data to recreate the error has been sent separately to Andrea Aime.

Cheers. Dan

Issue Links

depends upon

Bug - A problem which impairs or prevents the functions of the product. GEOS-1913 GeoServer KVP filter parser turns property filter into literal comparisons

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Dan Jones added a comment -

Example ogc:Filter xml file

Show
Dan Jones added a comment - Example ogc:Filter xml file
Hide
Permalink
Andrea Aime added a comment - - edited

So I've tried your queries with the sample data and I find no discrepancies. The first query you provided me:

<ogc:Filter xmlns:ogc="http://ogc.org" xmlns:gml="http://www.opengis.net/gml">
    <ogc:BBOX>
        <ogc:PropertyName>
            box
        </ogc:PropertyName>
        <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
            <gml:coordinates>
                -0.998694,53.564393 -0.672734,53.635659
            </gml:coordinates>
        </gml:Box>
    </ogc:BBOX>
</ogc:Filter>

returns 4 records, all of which are in the "Pipistrellus" spicies.

The second query is:

<ogc:Filter xmlns:ogc="http://ogc.org" xmlns:gml="http://www.opengis.net/gml">
    <ogc:And>
        <ogc:PropertyIsEqualTo>
            <ogc:PropertyName>
                scientificname
            </ogc:PropertyName>
            <ogc:Literal>
                Arvicola terrestris
            </ogc:Literal>
        </ogc:PropertyIsEqualTo>
        <ogc:BBOX>
            <ogc:PropertyName>
                box
            </ogc:PropertyName>
            <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
                <gml:coordinates>
                    -0.998694,53.564393 -0.672734,53.635659
                </gml:coordinates>
            </gml:Box>
        </ogc:BBOX>
    </ogc:And>
</ogc:Filter>

Which uses the same bbox, but a scientific name that's not there, thus the result is empty. I see no error in this...
Yet, I've tried replacing the Arvicola with Pipistrellus and the result is still empty, but only if I do the query with a GET, with a POST it works -> something is going on in the filter decoding in the GET request type

Show
Andrea Aime added a comment - - edited So I've tried your queries with the sample data and I find no discrepancies. The first query you provided me: 
<ogc:Filter xmlns:ogc="http://ogc.org" xmlns:gml="http://www.opengis.net/gml">
    <ogc:BBOX>
        <ogc:PropertyName>
            box
        </ogc:PropertyName>
        <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
            <gml:coordinates>
                -0.998694,53.564393 -0.672734,53.635659
            </gml:coordinates>
        </gml:Box>
    </ogc:BBOX>
</ogc:Filter>
returns 4 records, all of which are in the "Pipistrellus" spicies. The second query is: 
<ogc:Filter xmlns:ogc="http://ogc.org" xmlns:gml="http://www.opengis.net/gml">
    <ogc:And>
        <ogc:PropertyIsEqualTo>
            <ogc:PropertyName>
                scientificname
            </ogc:PropertyName>
            <ogc:Literal>
                Arvicola terrestris
            </ogc:Literal>
        </ogc:PropertyIsEqualTo>
        <ogc:BBOX>
            <ogc:PropertyName>
                box
            </ogc:PropertyName>
            <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
                <gml:coordinates>
                    -0.998694,53.564393 -0.672734,53.635659
                </gml:coordinates>
            </gml:Box>
        </ogc:BBOX>
    </ogc:And>
</ogc:Filter>
Which uses the same bbox, but a scientific name that's not there, thus the result is empty. I see no error in this... Yet, I've tried replacing the Arvicola with Pipistrellus and the result is still empty, but only if I do the query with a GET, with a POST it works -> something is going on in the filter decoding in the GET request type
Hide
Permalink
Andrea Aime added a comment -

Hum, so I've found out what the issue is, the parser get thrwn off by the improper namespace declaration, xmlns:ogc should be: xmlns:ogc="http://www.opengis.org/ogc" instead.

Show
Andrea Aime added a comment - Hum, so I've found out what the issue is, the parser get thrwn off by the improper namespace declaration, xmlns:ogc should be: xmlns:ogc="http://www.opengis.org/ogc" instead.
Hide
Permalink
Andrea Aime added a comment -

The problem is not in GeoServer, but in the request. Opened a separate issue to get some better error messages for this case

Show
Andrea Aime added a comment - The problem is not in GeoServer, but in the request. Opened a separate issue to get some better error messages for this case

People

  • Assignee:
    Andrea Aime
    Reporter:
    Dan Jones
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: