Opened 9 years ago

Closed 9 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
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 9 years ago.

Download all attachments as: .zip

Change History (2)

by mec, 9 years ago

Attachment: sort_test.dbf​ added

comment:1 by Even Rouault, 9 years ago

Component: default → OGR_SF
Keywords: sql null added
Milestone: → 1.11.4
Resolution: → fixed
Status: new → closed

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.