Bug 26042

Summary:	Koha/ItemTypes.t and Koha/Patrons.t are failing with latest MariaDB
Product:	Koha	Reporter:	Jonathan Druart <jonathan.druart>
Component:	Test Suite	Assignee:	Chris Cormack <chris>
Status:	CLOSED FIXED	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P5 - low	CC:	julian.maurice, martin.renvoize, tomascohen, victor
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26056
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:
Bug Depends on:
Bug Blocks:	25551

Description Jonathan Druart 2020-07-22 10:41:36 UTC

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

Comment 1 Jonathan Druart 2020-07-24 10:08:10 UTC

Note that Patrons.t is also failing

#   Failed test 'Return first guarantor alphabetically'
#   at t/db_dependent/Koha/Patrons.t line 233.
#          got: '2000000361'
#     expected: '2000000365'

#   Failed test 'Return second guarantor alphabetically'
#   at t/db_dependent/Koha/Patrons.t line 234.
#          got: '2000000362'
#     expected: '2000000364'

#   Failed test 'Return third guarantor alphabetically'
#   at t/db_dependent/Koha/Patrons.t line 235.
#          got: '2000000365'
#     expected: '2000000363'

#   Failed test 'Return fourth guarantor alphabetically'
#   at t/db_dependent/Koha/Patrons.t line 236.
#          got: '2000000364'
#     expected: '2000000362'

#   Failed test 'Return fifth guarantor alphabetically'
#   at t/db_dependent/Koha/Patrons.t line 237.
#          got: '2000000363'
#     expected: '2000000361'
# Looks like you failed 5 tests of 13.

Comment 2 Victor Grousset/tuxayo 2020-07-27 18:47:09 UTC

It doesn't look random since all builds of Koha_Master_D9_MDB_Latest failed since the upgrade 10.4=>10.5.
Should it be linked to an omnibus for MariaDB 10.5 support? (I can do it)

If I'm not mistaken there is at least one other MariaDB 10.5 known bug.

Comment 3 Jonathan Druart 2020-08-13 07:02:31 UTC

("Auto")Fixed since today, version is now 10.5.5-MariaDB-1:10.5.5+maria~focal