From 8a0e21f0ecfd7e5bd135ad30e8955960b5d3549d Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 6 Feb 2018 13:36:42 -0300
Subject: [PATCH] Bug 20144: [sql_modes] Remove useless ORDER BY clauses in
 tests

Fix for:
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 t/db_dependent/Creators/Lib.t | 2 --
 1 file changed, 2 deletions(-)

diff --git a/t/db_dependent/Creators/Lib.t b/t/db_dependent/Creators/Lib.t
index 858b886dad..c820fb73ef 100644
--- a/t/db_dependent/Creators/Lib.t
+++ b/t/db_dependent/Creators/Lib.t
@@ -403,7 +403,6 @@ $templates = get_all_templates( { orderby => 'rows DESC' } );
 $query = '
   SELECT    count(*)
   FROM      creator_templates
-  ORDER BY  rows DESC
   ';
 $count = $dbh->selectrow_array($query);
 is( $count,      2,      'There are 2 templates' );
@@ -579,7 +578,6 @@ $layouts = get_all_layouts( { orderby => 'font_size DESC' } );
 $query = '
   SELECT   count(*)
   FROM     creator_layouts
-  ORDER BY font_size DESC
   ';
 $count = $dbh->selectrow_array($query);
 is( $count,    2,      'There are layout matching' );
-- 
2.20.1