Sort by integer giving string sort

[ashik-aufaitux]

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Application (please complete the following information):

• App client [e.g. MySQL]
• App version [e.g. 0.5.2]
• Installation source: [e.g. exe, Linux Store, AppImage, dmg]

Environment (please complete the following information):

• OS name: [e.g. Windows 11]
• OS version [e.g. 21H2]
• DB name [e.g. MariaDB]
• DB version [e.g. 10.3.34]

Additional context
Add any other context about the problem here.

[Fabio286]

Hi @ashik-aufaitux ,

Which version of Antares are you using?

[ashik-aufaitux]

Version 0.7.30

…

________________________________ From: Fabio Di Stasio ***@***.***> Sent: Monday, December 9, 2024 12:41 PM To: antares-sql/antares ***@***.***> Cc: Ashik C K ***@***.***>; Mention ***@***.***> Subject: Re: [antares-sql/antares] Sort by integer giving string sort (Issue #904) Hi @ashik-aufaitux<https://github.com/ashik-aufaitux> , Which version of Antares are you using? — Reply to this email directly, view it on GitHub<#904 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BHBZUPWE33A3MUWWV5U4G6T2EU7AJAVCNFSM6AAAAABTIABD6WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKMRXGEYTGNBWGY>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[Fabio286]

Can you tell me what database the problem occurs on and what type is that number field?
Where did you install Antares from?

[ashik-aufaitux]

Its in MySql database and primary key id field. I have installed it from https://antares-sql.app/ and it gets updated automatically.

[D-nov]

Just logged in to report the same bug...
is there like "bump" button or something that I need to press to mark that I also have the same issue?

[Fabio286]

Just logged in to report the same bug... is there like "bump" button or something that I need to press to mark that I also have the same issue?

I have made some tests but cannot replicate the problem.
Could you give me more information about the context?
For example from what operating system and what type of data contains the field with the problem, e.g. INT, BIGINT, TINYINT etc.

[D-nov]

sure, here it is:
My setup is Ubuntu (whatever is latest 24.xx)
MariaDB: mysql Ver 15.1 Distrib 10.11.8-MariaDB
Antares: 0.7.30, but I think this bug has been here for a while

Id column of type BIGINT, length 20, unsigned, autoincrement (this is the most obvious one because i use it daily)
also VARCHAR 255 seem to sort weird because 010 comes before 002

so far I only noticed those

[Fabio286]

Currently, Antares, for tables that have fewer records than the result limit (1000 by default) performs a software-side sort, without redoing the query.
However, I realise that there are situations in which this leads to anomalous results, or in any case not in line with what the database would return, according to its settings.
Therefore from the next release all sort will be the result of a query. On the user side, nothing will change, but at least these anomalous situations should disappear.