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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
