Opened 12 years ago

Closed 12 years ago

#1557 closed defect (fixed)

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 (1)

comment:2 Changed 12 years ago by warmerdam

Resolution: fixed
Status: newclosed

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.