#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
Cc:

Description

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 19 months ago.

Download all attachments as: .zip

Change History (2)

Changed 19 months ago by mec

Attachment: sort_test.dbf added

comment:1 Changed 19 months ago by Even Rouault

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.