Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-07-12 11:18:26 +0200
committerErich Eckner <git@eckner.net>2019-07-12 11:18:26 +0200
commitcb0dea0f3eb2d7c6beb7fad244ae2d256806e21b (patch)
tree14945765fa888071c9a5ae9cb0c183a4302bcf78
parent1c7a63ff2b8d7d7dfe51d26b97cf16d06c93a08e (diff)
lib/mysql-functions: mysql_load_min_and_max_versions() should ignore versions with `order`=NULL
-rwxr-xr-xlib/mysql-functions4
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'
} | \