Bug: Sorting BOM list by product reference not working properly

[kupfair]

Instructions

This is a template to help you report good issues. You may use Github Markdown syntax to format your issue report.
Please:

• replace the bracket enclosed texts with meaningful information
• remove any unused sub-section

Bug

[Sorting the BOM by product reference is not working as usual in alphabetic order on the first character]

Environment

• Version: 18.0.1
• OS: Linux
• Web server: Apache
• PHP: fpm-fcgi 7.4.33
• Database: MySQL or MariaDB 5.5.5-10.4.25-MariaDB-1:10.4.25+maria~stretch-log
• URL(s): /bom/bom_list.php?leftmenu=bom

Expected and actual behavior

[Like in the other columns in the BOM List, one would expect that the Product Ref sorts in alphanumeric order, which is not the case whereas it works in a normal Product List]

Steps to reproduce the behavior

[Just using it]

Attached files (Screenshots, screencasts, dolibarr.log, debugging informations…)

[Files]

Report

[Ashley-Butcher]

Bug exists in 18.0.2 too.

[erikvanberkum]

issue earlier reported here #18713

issue now solved in the mo_list.php sort on p.label but the issue is not solved in bom_list.php

[hregis]

@erikvanberkum try with this fix : #32497