| Anonymous | Login | Signup for a new account | 2010-09-05 00:28 EDT |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ << ] [ >> ] | [ Issue History ] [ Print ] | |||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||
| 0001040 | Sqlite Developer | GUI | public | 2010-05-29 02:00 | 2010-05-31 23:01 | ||||||
| Reporter | Gillissie | ||||||||||
| Assigned To | sharpplus | ||||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||||
| Status | assigned | Resolution | open | ||||||||
| Platform | OS | OS Version | |||||||||
| Product Version | |||||||||||
| Target Version | Fixed in Version | ||||||||||
| Summary | 0001040: sorting numeric data as text | ||||||||||
| Description | This seems to be a new bug because I don't think it always did this until recently. When viewing data in a table, clicking a column header will sort by that column. Sorting by a numeric column is treating the data like text for sorting purposes. This results in sorts like this: 0 1 10 11 2 3 .... | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0000270) sharpplus (administrator) 2010-05-30 08:54 |
Dear Gillissie, Are you sure your field is mapped to a number data type? If your field is mapped to the default string data type, the sort result will like what you observed. I just create a table with a integer field and can not reproduce the problem. Would you please use options | General | Data type to map your field to integer or int64 and check again? |
|
(0000271) Gillissie (reporter) 2010-05-31 23:01 |
I am certain that it is an integer type. It happens on any integer type field, not just a certain one. When I do that data type mapping from int to Integer, the sorting is correct. Why wouldn't it just recognize int as Integer automatically? It used to, I'm tell you. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-05-29 02:00 | Gillissie | New Issue | |
| 2010-05-30 08:54 | sharpplus | Note Added: 0000270 | |
| 2010-05-30 08:54 | sharpplus | Assigned To | => sharpplus |
| 2010-05-30 08:54 | sharpplus | Status | new => feedback |
| 2010-05-31 23:01 | Gillissie | Note Added: 0000271 | |
| 2010-05-31 23:01 | Gillissie | Status | feedback => assigned |
|
Issue History |
| Copyright © 2000 - 2010 MantisBT Group |
 |