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 |
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)
Change History (2)
by , 8 years ago
Attachment: | sort_test.dbf added |
---|
comment:1 by , 8 years ago
Component: | default → OGR_SF |
---|---|
Keywords: | sql null added |
Milestone: | → 1.11.4 |
Resolution: | → fixed |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
trunk r31015, branches/2.0 r31016, branches/1.11 r31017 "OGRSQL: correctly sort NULL values in first positions (#6155)"