Sorting on column now show correct display data

[atanaspuskulev]

Wrongly column data sorting
I have a MariaDB table with several columns. One of them, may or may not contain data (empty). When sorting this particular column, it is not correctly sorting the data. If there's an empty cell(s) in the display - they're always on the top. Actually the entire rows of the table are not being sorted by the view. Happens when visually sorting via the column name by clicking it.

To Reproduce
Steps to reproduce the behavior:

1. Have a table with couple of columns, let's for example of of them has no data(empty):

++++++++++++++++++++++++++++
| id | title | some_type | date |
++++++++++++++++++++++++++++
| 1 | Smt | type_1 | 2024|

| 2 | Smt1 | type_2 | 2023|

| 3 | Smt2 | | 2023|

| 4 | Smt3 | | 2022|

2. Click on sort by "some_type" to actually sort the data;
3. See of the sorting work
4. You will notice that the empty rows are always unsorted and then the next with actual data are.

Expected behavior
Sort even the empty cells ASC/DESC and accordingly display the results.

Screenshots

Application (please complete the following information):

• MariaDB
• 0.7.28
• Linux (Ubuntu) via the app center.

Environment (please complete the following information):

• Kubuntu
• 24.10
• MariaDB
• 11.5.2

Additional context
N/A

[bart-schaefer]

This is a known behavior of the ORDER BY operation in MariaDB. See here:
https://mariadb.com/kb/en/order-by/