Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-31 15:41:08 +0200
committerErich Eckner <git@eckner.net>2018-05-31 15:41:08 +0200
commit5b6581935b8c1d64313c812e6bfa3d0309aaea18 (patch)
tree723912bc40fcb599152e38b7bcb45a1bc1daa675 /bin
parent8dde526290718371b6da178c65955d431910fd97 (diff)
count(*) -> COUNT(1)
Diffstat (limited to 'bin')
-rwxr-xr-xbin/get-assignment2
-rwxr-xr-xbin/ping-from-slave2
-rwxr-xr-xbin/why-dont-you2
3 files changed, 3 insertions, 3 deletions
diff --git a/bin/get-assignment b/bin/get-assignment
index 0bfe48f..c8fcbaf 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -176,7 +176,7 @@ fi
count_pending=$(
# shellcheck disable=SC2016
{
- printf 'SELECT count(*)'
+ printf 'SELECT COUNT(1)'
printf ' FROM `build_assignments`'
mysql_join_build_assignments_binary_packages
mysql_join_binary_packages_binary_packages_in_repositories
diff --git a/bin/ping-from-slave b/bin/ping-from-slave
index 6246b02..55a3300 100755
--- a/bin/ping-from-slave
+++ b/bin/ping-from-slave
@@ -13,7 +13,7 @@
if [ "$(
# shellcheck disable=SC2016,SC2154
{
- printf 'SELECT count(*) FROM `build_slaves`'
+ printf 'SELECT COUNT(1) FROM `build_slaves`'
mysql_join_build_slaves_build_assignments
printf ' WHERE `build_slaves`.`name`=from_base64("%s");\n' \
"$(printf '%s' "${slave}" | base64 -w0)"
diff --git a/bin/why-dont-you b/bin/why-dont-you
index e35e0bd..b05f98e 100755
--- a/bin/why-dont-you
+++ b/bin/why-dont-you
@@ -44,7 +44,7 @@ case "${action}" in
printf 'SELECT DISTINCT `to_build`.`ba_id`,'
printf 'If(`to_build`.`is_broken`,1,0),'
printf '('
- printf 'SELECT count(*) FROM `failed_builds`'
+ printf 'SELECT COUNT(1) FROM `failed_builds`'
printf 'WHERE `failed_builds`.`build_assignment`=`to_build`.`ba_id`'
printf ')'
printf ',replace(to_base64(`%s`.`%s`),"\\n","")' \