jakob / jakob/Postico

wrong ordering of results with alpha-num strings

Open
#266 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

I had an issue when manually sorting a result set with alpha-numerical transaction ids.
Here is reduced sample:

``` SQL
SELECT x
FROM unnest(ARRAY[
'0AH700', '1CH859', '2LP231', '3NM022', '03P758', '3SF762',
'4FP507', '5VW585', '6M8723', '7VP948', '9AK289', '15U924',
'39M313', '61W694', '75E749', '141925', '300280'
]) AS x;
```

![wrong ordering](https://cloud.githubusercontent.com/assets/384993/18454025/5be4ff08-7942-11e6-8398-99bda691afb7.png)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reduced SQL sample in Postico and inspect the result-set sorting entry point. Compare the displayed order with the expected ordering for the alphanumeric transaction IDs; done means manual sorting produces a confirmed, consistent order for this sample.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.