https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42979 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |38122 Assignee|chris@bigballofwax.co.nz |jonathan.druart@gmail.com Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38122 [Bug 38122] Cannot sort holdings table by status -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42979 --- Comment #1 from Jonathan Druart <jonathan.druart@gmail.com> --- Created attachment 201423 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=201423&action=edit Bug 42979: Prevent failure on My8 In MySQL8 the order on the PK is not preserved. We need to explicitely pass it. Test plan: export DB_IMAGE=mysql:8.0; then startup ktd % prove t/db_dependent/api/v1/biblios.t should pass with this patch Without this patch it failed with: 13:00:29 # Failed test 'exact match for JSON Pointer "/4/item_id"' 13:00:29 # at t/db_dependent/api/v1/biblios.t line 276. 13:00:34 # got: '3420' 13:00:36 # expected: '3417' 13:00:37 13:00:38 # Failed test 'Withdrawn comes after lost' 13:00:57 # at t/db_dependent/api/v1/biblios.t line 276. 13:00:59 # got: '3417' 13:01:04 # expected: '3420' 13:01:05 # Looks like you failed 2 tests of 8. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42979 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42979 --- Comment #2 from David Nind <david@davidnind.com> --- Created attachment 201472 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=201472&action=edit Bug 42979: Prevent failure on My8 In MySQL8 the order on the PK is not preserved. We need to explicitely pass it. Test plan: export DB_IMAGE=mysql:8.0; then startup ktd % prove t/db_dependent/api/v1/biblios.t should pass with this patch Without this patch it failed with: 13:00:29 # Failed test 'exact match for JSON Pointer "/4/item_id"' 13:00:29 # at t/db_dependent/api/v1/biblios.t line 276. 13:00:34 # got: '3420' 13:00:36 # expected: '3417' 13:00:37 13:00:38 # Failed test 'Withdrawn comes after lost' 13:00:57 # at t/db_dependent/api/v1/biblios.t line 276. 13:00:59 # got: '3417' 13:01:04 # expected: '3420' 13:01:05 # Looks like you failed 2 tests of 8. Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.