Opened 5 years ago

Closed 5 years ago

Last modified 5 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 Changed 5 years ago by rouault

  • Component changed from Utilities to OGR_SF
  • Keywords ogr sql distinct null added
  • Milestone set to 1.9.0
  • Resolution set to fixed
  • Status changed from new to closed
  • Version svn-trunk deleted

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 5 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 5 years ago by rouault

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.