Opened 8 years ago

Closed 8 years ago

#6155 closed defect (fixed)

DBF Text-Sorting Issue with NULL Values (ORDER BY)

Reported by: mec Owned by: warmerdam
Priority: normal Milestone: 1.11.4
Component: OGR_SF Version: 1.11.1
Severity: normal Keywords: sql null


Sorting a DBF table with using the ESRI Shapefile driver will result in a partially sorted table if there are null values in that column.

Example using the attached data (sort_test.dbf):

ogr2ogr -sql "SELECT * FROM sort_test ORDER BY text_value" sort_test.dbf out.dbf

Attachments (1)

sort_test.dbf (4.0 KB ) - added by mec 8 years ago.

Download all attachments as: .zip

Change History (2)

by mec, 8 years ago

Attachment: sort_test.dbf added

comment:1 by Even Rouault, 8 years ago

Component: defaultOGR_SF
Keywords: sql null added
Milestone: 1.11.4
Resolution: fixed
Status: newclosed

trunk r31015, branches/2.0 r31016, branches/1.11 r31017 "OGRSQL: correctly sort NULL values in first positions (#6155)"

Note: See TracTickets for help on using tickets.