diff options
author | Erich Eckner <git@eckner.net> | 2019-07-12 11:18:26 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2019-07-12 11:18:26 +0200 |
commit | cb0dea0f3eb2d7c6beb7fad244ae2d256806e21b (patch) | |
tree | 14945765fa888071c9a5ae9cb0c183a4302bcf78 /lib | |
parent | 1c7a63ff2b8d7d7dfe51d26b97cf16d06c93a08e (diff) | |
download | builder-cb0dea0f3eb2d7c6beb7fad244ae2d256806e21b.tar.xz |
lib/mysql-functions: mysql_load_min_and_max_versions() should ignore versions with `order`=NULL
Diffstat (limited to 'lib')
-rwxr-xr-x | lib/mysql-functions | 4 |
1 files changed, 4 insertions, 0 deletions
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' } | \ |