Opened 9 years ago

Closed 9 years ago

Last modified 9 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


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

  ICC (String) =         # no (null) here

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

Change History (3)

comment:1 Changed 9 years ago by Even Rouault

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 Changed 9 years ago by peifer

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 Changed 9 years ago by Even Rouault

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

Note: See TracTickets for help on using tickets.