Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
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 /lib/mysql-functions
parent8dde526290718371b6da178c65955d431910fd97 (diff)
count(*) -> COUNT(1)
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions6
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 52f0ef2..9470579 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -828,7 +828,7 @@ mysql_cleanup() {
if [ "$#" = '0' ]; then
operator='DELETE'
elif [ "$#" = '1' ] && [ "x$1" = 'xdry' ]; then
- operator='SELECT COUNT(*)'
+ operator='SELECT COUNT(1)'
else
>&2 echo 'Unknown parameter'
>&2 echo 'Call "mysql_clean_up" or "mysql_clean_up dry".'
@@ -892,7 +892,7 @@ mysql_cleanup() {
printf 'UPDATE `build_slaves`'
printf ' SET `build_slaves`.`currently_building`=NULL'
else
- printf 'SELECT COUNT(*) FROM `build_slaves`'
+ printf 'SELECT COUNT(1) FROM `build_slaves`'
fi
printf ' WHERE `build_slaves`.`currently_building` IS NOT NULL'
printf ' AND TIMEDIFF(NOW(),('
@@ -905,7 +905,7 @@ mysql_cleanup() {
printf ' SET `build_slaves`.`last_action`=NULL,'
printf ' `build_slaves`.`logged_lines`=NULL'
else
- printf 'SELECT COUNT(*) FROM `build_slaves`'
+ printf 'SELECT COUNT(1) FROM `build_slaves`'
fi
printf ' WHERE `build_slaves`.`currently_building` IS NULL'
printf ' AND (`build_slaves`.`last_action` IS NOT NULL'