Ticket #1557 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

OGR SQL/AttributeFilters lack string < and > comparisons

Reported by: warmerdam Assigned to: warmerdam
Priority: normal Milestone: 1.4.1
Component: OGR_SF Version: 1.4.0
Severity: normal Keywords: sql
Cc:

Description

The > and < operation cannot be used in OGR SQL WHERE clauses or SetAttributeFilter?() calls for drivers that let OGR interprete the attribute filter.

Change History

04/04/07 13:12:02 changed by warmerdam

  • status changed from new to closed.
  • resolution set to fixed.

I have implemented support for >, <, >=, and <= in trunk and 1.4 branch.

I have added a small test in trunk to ogr/ogr_sql_test.py

I have updated the ogr_sql.dox in trunk and 1.4 branch.

The quirky thing with the implementation is that it uses a case sensitive string comparison (strcmp()) instead of the case insensitive string comparison used by the equality test.