summaryrefslogtreecommitdiff
path: root/bin/build-master-status
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-01 11:06:41 +0200
committerErich Eckner <git@eckner.net>2018-06-01 11:06:41 +0200
commite0c167a65916bf995add39aec94f5f524af834e4 (patch)
treee828228392ecdc50115468c7384c0e0353b2382b /bin/build-master-status
parentb72da8d58250ade67c3315545665cd2f77c86d01 (diff)
downloadbuilder-e0c167a65916bf995add39aec94f5f524af834e4.tar.xz
make `binary_packages`.`is_to_be_deleted` and `binary_packages`.`last_moved` obsolete; cleanup some queries
Diffstat (limited to 'bin/build-master-status')
-rwxr-xr-xbin/build-master-status6
1 files changed, 3 insertions, 3 deletions
diff --git a/bin/build-master-status b/bin/build-master-status
index f1f4ed9..9636722 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -79,7 +79,7 @@ if [ -s "${tmp_dir}/todos" ]; then
printf ' WHERE `td`.`id` IS NULL;\n'
printf 'DELETE FROM `todos` WHERE NOT EXISTS ('
- printf 'SELECT * FROM `td`'
+ printf 'SELECT 1 FROM `td`'
printf ' AND `td`.`%s`=`todos`.`%s`' \
'file' 'file' \
'line' 'line' \
@@ -88,10 +88,10 @@ if [ -s "${tmp_dir}/todos" ]; then
printf ');\n'
printf 'DROP TEMPORARY TABLE `td`;\n'
printf 'DELETE FROM `todo_links` WHERE NOT EXISTS ('
- printf 'SELECT * FROM `todos` '
+ printf 'SELECT 1 FROM `todos` '
printf 'WHERE `todos`.`id`=`todo_links`.`depending_on`'
printf ') OR NOT EXISTS ('
- printf 'SELECT * FROM `todos` '
+ printf 'SELECT 1 FROM `todos` '
printf 'WHERE `todos`.`id`=`todo_links`.`dependent`'
printf ');\n'
} | \