diff options
| author | Erich Eckner <git@eckner.net> | 2018-05-31 15:41:08 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-05-31 15:41:08 +0200 |
| commit | 5b6581935b8c1d64313c812e6bfa3d0309aaea18 (patch) | |
| tree | 723912bc40fcb599152e38b7bcb45a1bc1daa675 /bin | |
| parent | 8dde526290718371b6da178c65955d431910fd97 (diff) | |
| download | builder-5b6581935b8c1d64313c812e6bfa3d0309aaea18.tar.xz | |
count(*) -> COUNT(1)
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/get-assignment | 2 | ||||
| -rwxr-xr-x | bin/ping-from-slave | 2 | ||||
| -rwxr-xr-x | bin/why-dont-you | 2 |
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","")' \ |