Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#5333 closed defect (fixed)

Min and Max date for Shapefiles return NULL

Reported by: anitagraser Owned by: warmerdam
Priority: normal Milestone: 1.11.0
Component: OGR_SF Version: 1.10.1
Severity: normal Keywords: ogr sql min max date
Cc:

Description

Min and Max date for Shapefiles return NULL. The issue was noted in QGIS (http://hub.qgis.org/issues/9241).

    $ ogrinfo /tmp/test/test2.shp -sql "SELECT MAX( 'DATE' ) from test2" 
    $ 
    $ INFO: Open of `/tmp/test/test2.shp'
    $   using driver `ESRI Shapefile' successful.
    $ 
    $ Layer name: test2
    $ Geometry: 3D Point
    $ Feature Count: 1
    $ Layer SRS WKT:
    $ (unknown)
    $ MAX_DATE: Date (10.0)
    $ OGRFeature(test2):0
    $   MAX_DATE (Date) = (null)

Change History (3)

comment:1 Changed 3 years ago by Even Rouault

Component: defaultOGR_SF
Keywords: ogr sql min max date added

trunk r26742 : "OGR SQL: implement MIN(), MAX() and AVG() on a date (#5333)"

trunk r26743 : "OGR SQL: Test MIN, MAX and AVG on a date (#5333)"

comment:2 Changed 3 years ago by Even Rouault

Milestone: 2.0
Resolution: fixed
Status: newclosed

comment:3 Changed 3 years ago by Even Rouault

Milestone: 2.01.11.0
Note: See TracTickets for help on using tickets.