Bug 24396: Fix Suggestions.t with MySQL 8
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 10 Jan 2020 10:29:15 +0000 (11:29 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 10 Jan 2020 10:54:28 +0000 (10:54 +0000)
commit2278ff2b08e3e3b4ddd320fa665ee468420874bf
tree662c8de9e855c1d24b0ed49a2371d73095017d88
parent1c38ddf41032a7da72ce8dedead385e581bf1ff6
Bug 24396: Fix Suggestions.t with MySQL 8

 #   Failed test 'DelSuggestion deletes the correct suggestion'
 #   at t/db_dependent/Suggestions.t line 413.
 #          got: 'my title 3'
 #     expected: 'my deleted title'
 t/db_dependent/Suggestions.t .. 112/113 # Looks like you failed 1 test of 113.

Suggestions were returned in the reverse order. Adding an ORDER BY clause fixes the problem.

Test plan:
 % prove t/db_dependent/Suggestions.t
must return green

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/Suggestions.pm