From cb0dea0f3eb2d7c6beb7fad244ae2d256806e21b Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 12 Jul 2019 11:18:26 +0200
Subject: lib/mysql-functions: mysql_load_min_and_max_versions() should ignore
 versions with `order`=NULL

---
 lib/mysql-functions | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'lib/mysql-functions')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index bf66a73..548ee00 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1526,6 +1526,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order`'
         printf ' LIMIT 1'
       } | \
@@ -1538,6 +1539,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order` DESC'
         printf ' LIMIT 1'
       } | \
@@ -1550,6 +1552,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT `versions`.`id`'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order`'
         printf ' LIMIT 1'
       } | \
@@ -1562,6 +1565,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT `versions`.`id`'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order` DESC'
         printf ' LIMIT 1'
       } | \
-- 
cgit v1.2.3-54-g00ecf