diff options
author | Erich Eckner <git@eckner.net> | 2018-06-01 11:06:41 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-06-01 11:06:41 +0200 |
commit | e0c167a65916bf995add39aec94f5f524af834e4 (patch) | |
tree | e828228392ecdc50115468c7384c0e0353b2382b /bin/build-master-status | |
parent | b72da8d58250ade67c3315545665cd2f77c86d01 (diff) | |
download | builder-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-x | bin/build-master-status | 6 |
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' } | \ |