Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#4353 closed defect (fixed)

ogrinfo: display of (null) -- or not

Reported by: peifer Owned by: warmerdam
Priority: normal Milestone: 1.9.0
Component: OGR_SF Version:
Severity: normal Keywords: ogr sql distinct null
Cc:

Description

$ ogrinfo NUTS_3.shp -sql "select distinct ICC from NUTS_3"

...
OGRFeature(NUTS_3):37
  ICC (String) =         # no (null) here

$ ogrinfo NUTS_3.shp -sql "select ICC from NUTS_3 where FID=1399"
...
OGRFeature(NUTS_3):1399
  ICC (String) = (null)  # ..but here

Change History (3)

comment:1 by Even Rouault, 12 years ago

Component: UtilitiesOGR_SF
Keywords: ogr sql distinct null added
Milestone: 1.9.0
Resolution: fixed
Status: newclosed
Version: svn-trunk

r23421 /trunk/ (4 files in 3 dirs): OGR SQL: with DISTINCT, consider null values are such, and not as empty string (#4353)

comment:2 by peifer, 12 years ago

Thanks for taking care. I noted that this time, your changes/additions in the code had substantially more lines than my bug report.

comment:3 by Even Rouault, 12 years ago

r23429 /trunk/autotest/ogr/ (ogr_mem.py ogr_shape.py): SELECT DISTINCT returns null values instead of 0 now. Adjust tests (#4353)

Note: See TracTickets for help on using tickets.