Changeset 84097 in vbox for trunk/src/VBox/ValidationKit/testmanager/core/testbox.py

Timestamp:

Apr 30, 2020 10:35:14 AM (5 years ago)

Author:

vboxsync

Message:

TestManager/testbox.py: Fix for names with lots of digits in them.

File:

• trunk/src/VBox/ValidationKit/testmanager/core/testbox.py (modified) (1 diff)

trunk/src/VBox/ValidationKit/testmanager/core/testbox.py

@@ -745 +745 @@
     kdSortColumnMap                 = {
         0:                               'TestBoxesWithStrings.sName',
-        kiSortColumn_sName:              "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*','', 'g'), "\
-                                         "regexp_replace(CONCAT(TestBoxesWithStrings.sName,'0'),'[^0-9]*','', 'g')::int",
-        -kiSortColumn_sName:             "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*','', 'g') DESC, "\
-                                         "regexp_replace(CONCAT(TestBoxesWithStrings.sName,'0'),'[^0-9]*','', 'g')::int DESC",
+        kiSortColumn_sName:              "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*', '', 'g'), " \
+                            "RIGHT(CONCAT(regexp_replace(TestBoxesWithStrings.sName,'[^0-9]*','', 'g'),'0'),8)::int",
+        -kiSortColumn_sName:             "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*', '', 'g') DESC, " \
+                            "RIGHT(CONCAT(regexp_replace(TestBoxesWithStrings.sName,'[^0-9]*','', 'g'),'0'),8)::int DESC",
         kiSortColumn_sOs:                'TestBoxesWithStrings.sOs',
         -kiSortColumn_sOs:               'TestBoxesWithStrings.sOs DESC',