Ticket #1557 (closed defect: fixed)

Opened 5 years ago

Last modified 5 years ago

OGR SQL/AttributeFilters lack string < and > comparisons

Reported by: warmerdam Owned by: 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

Changed 5 years ago 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.

Note: See TracTickets for help on using tickets.