[Koha-bugs] [Bug 26042] New: Koha/ItemTypes.t is failing with latest MariaDB

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042

            Bug ID: 26042
           Summary: Koha/ItemTypes.t is failing with latest MariaDB
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Test Suite
          Assignee: chris at bigballofwax.co.nz
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org

Failing on Master_D9_MDB_Latest
https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/346/consoleFull

But I recreate on D10 locally.

The test is failing with:
#   Failed test 'item types should be sorted by translated description'
#   at t/db_dependent/Koha/ItemTypes.t line 137.
#          got: 'b translated itemtype desc'
#     expected: 'a translated itemtype desc'
# Looks like you failed 1 test of 24.

The generated query is (without the full field list):
SELECT `me`.`itemtype`, COALESCE( `localization`.`translation`,
`me`.`description` ) AS `translated_description` FROM `itemtypes` `me` LEFT
JOIN (SELECT localization_id, code, lang, translation FROM localization WHERE
entity='itemtypes') `localization` ON ( `localization`.`lang` = 'en' AND
`me`.`itemtype` = `localization`.`code` ) ORDER BY `translated_description`;

I have removed the transaction and run the query in the MariaDB CLI:
*************************** 1. row ***************************
              itemtype: type1
translated_description: b translated itemtype desc
*************************** 2. row ***************************
              itemtype: type2
translated_description: a translated itemtype desc
*************************** 3. row ***************************
              itemtype: type3
translated_description: description
*************************** 4. row ***************************
              itemtype: woR9bd5
translated_description: nlHDyp


MariaDB version is: 10.5.4-MariaDB-1:10.5.4+maria~focal

-- 
You are receiving this mail because:
You are watching all bug changes.