Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Not a Bug
-
None
-
None
-
None
Description
We've found a bug with wrong sort ordering of text data when using ORDER BY. Plase see the attached sql-file with test data. After importing it if you run:
select * from test_items_g order by item_name;
you'd see almost at the end of the list:
| 96 | Aurora RH04 255/70R16 109S | 3 | 5399.00 |
| 95 | Aurora RH04 245/75R16 120Q | 3 | 5936.00 |
| 94 | Aurora RH04 245/75R16 109S | 3 | 6062.00 |
| 93 | Aurora RH04 235/75R15 104S | 3 | 4588.00 |
now almost the same query with extra WHERE:
> select * from test_items_g where item_name like "Aurora RH04%" order by item_name;
----------------------------------------------------------+
| item_id | item_name | manufacturer_id | price |
----------------------------------------------------------+
| 93 | Aurora RH04 235/75R15 104S | 3 | 4588.00 |
| 94 | Aurora RH04 245/75R16 109S | 3 | 6062.00 |
| 95 | Aurora RH04 245/75R16 120Q | 3 | 5936.00 |
| 96 | Aurora RH04 255/70R16 109S | 3 | 5399.00 |
----------------------------------------------------------+
4 rows in set (0.01 sec)
This happens with MariaDB installed from package 5.2.9-mariadb102~squeeze (amd64 version) on Debian Squeeze with kernel 2.6.32-bpo.4-amd64