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@bigballofwax.co.nz Reporter: jonathan.druart@bugs.koha-community.org QA Contact: testopia@bugs.koha-community.org Failing on Master_D9_MDB_Latest https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/346/console... 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.