[monitoring-plugins] - fix for issue #1562

[ghciv6]

 Module: monitoring-plugins
 Branch: master
 Commit: b8b87b55d61aceff03107b0335347257f429e9ad
 Author: ghciv6 <ghciv6@localhost>
   Date: Tue Sep 15 21:36:27 2020 +0200
    URL: 
https://www.monitoring-plugins.org/repositories/monitoring-plugins/commit/?id=b8b87b5

- fix for issue #1562
  1st compare then free up resources

---

 plugins/check_mysql_query.c | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/plugins/check_mysql_query.c b/plugins/check_mysql_query.c
index 49a14dd..ac2fb15 100644
--- a/plugins/check_mysql_query.c
+++ b/plugins/check_mysql_query.c
@@ -136,18 +136,18 @@ main (int argc, char **argv)
                die (STATE_CRITICAL, "QUERY %s: Fetch row error - %s\n", 
_("CRITICAL"), error);
        }
 
-       /* free the result */
-       mysql_free_result (res);
-
-       /* close the connection */
-       mysql_close (&mysql);
-
        if (! is_numeric(row[0])) {
                die (STATE_CRITICAL, "QUERY %s: %s - '%s'\n", _("CRITICAL"), 
_("Is not a numeric"), row[0]);
        }
 
        value = strtod(row[0], NULL);
 
+       /* free the result */
+       mysql_free_result (res);
+
+       /* close the connection */
+       mysql_close (&mysql);
+
        if (verbose >= 3)
                printf("mysql result: %f\n", value);