bin/bootstrap-mysql,misc/database-layout.dump: "EXISTS (SELECT * FROM ...)" -> "EXISTS (SELECT 1 FROM ...)"

2 files changed, 14 insertions, 14 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index 2bcd212..35f5398 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -454,19 +454,19 @@ if [ ! "$1" = 'slim' ]; then
     printf ' AND `dependency_types`.`relevant_for_binary_packages`'
     # ... by a not-deleted, "more stable" package already in place or ...
     printf ' WHERE NOT EXISTS ('
-      printf 'SELECT * FROM `install_target_providers`'
+      printf 'SELECT 1 FROM `install_target_providers`'
       mysql_join_install_target_providers_binary_packages '' 'prov_bp'
       mysql_join_binary_packages_repositories 'prov_bp' 'prov_r'
       printf ' JOIN `repository_stability_relations` ON `prov_r`.`stability`=`repository_stability_relations`.`more_stable`'
       printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`'
       printf ' AND `target_repositories`.`stability`=`repository_stability_relations`.`less_stable`'
       printf ' AND NOT EXISTS ('
-        printf 'SELECT * FROM `replaced_binary_packages_copy`'
+        printf 'SELECT 1 FROM `replaced_binary_packages_copy`'
         printf ' WHERE `replaced_binary_packages_copy`.`id`=`prov_bp`.`id`'
       printf ')'
     # ... by a moved package
     printf ') AND NOT EXISTS ('
-      printf 'SELECT * FROM `install_target_providers`'
+      printf 'SELECT 1 FROM `install_target_providers`'
       printf ' JOIN `moveable_binary_packages_copy` ON `moveable_binary_packages_copy`.`id`=`install_target_providers`.`package`'
       printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`'
     printf ');\n'
@@ -506,7 +506,7 @@ if [ ! "$1" = 'slim' ]; then
     mysql_join_install_target_providers_dependencies
     printf ' AND NOT EXISTS ('
       # dependencies of replaced packages don't matter
-      printf 'SELECT * FROM `replaced_binary_packages_copy`'
+      printf 'SELECT 1 FROM `replaced_binary_packages_copy`'
       printf ' WHERE `replaced_binary_packages_copy`.`id`=`dependencies`.`dependent`'
     printf ')'
     mysql_join_dependencies_dependency_types
@@ -523,7 +523,7 @@ if [ ! "$1" = 'slim' ]; then
     # a) ^
     printf ' WHERE NOT EXISTS ('
       # no moved package ...
-      printf 'SELECT *'
+      printf 'SELECT 1'
       printf ' FROM `moveable_binary_packages_copy`'
       mysql_join_binary_packages_install_target_providers 'moveable_binary_packages_copy' 'subst_itp'
       # ... provides the same
@@ -531,7 +531,7 @@ if [ ! "$1" = 'slim' ]; then
     # b) 1) ^
     printf ') AND NOT EXISTS ('
       # no current package ...
-      printf 'SELECT *'
+      printf 'SELECT 1'
       printf ' FROM `binary_packages` AS `subst_bp`'
       mysql_join_binary_packages_install_target_providers 'subst_bp' 'subst_itp'
       # ... in a repository ...
@@ -543,7 +543,7 @@ if [ ! "$1" = 'slim' ]; then
       printf ' WHERE `subst_rr`.`less_stable`=`repl_r`.`stability`'
       printf ' AND NOT EXISTS ('
       # ... and which is not replaced ...
-        printf 'SELECT * FROM `replaced_binary_packages_copy2`'
+        printf 'SELECT 1 FROM `replaced_binary_packages_copy2`'
         printf ' WHERE `replaced_binary_packages_copy2`.`id`=`subst_bp`.`id`'
       printf ')'
       # ... and provides the same
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index d35d100..e27afbd 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -133,7 +133,7 @@ DELETE `replaced_binary_packages`,`moveable_binary_packages`
 	JOIN `dependency_types`
 	ON `dependencies`.`dependency_type`=`dependency_types`.`id` AND `dependency_types`.`relevant_for_binary_packages`
 	WHERE NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `install_target_providers`
 	JOIN `binary_packages` AS `prov_bp`
 	ON `install_target_providers`.`package`=`prov_bp`.`id`
@@ -142,10 +142,10 @@ SELECT *
 	JOIN `repository_stability_relations`
 	ON `prov_r`.`stability`=`repository_stability_relations`.`more_stable`
 	WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on` AND `target_repositories`.`stability`=`repository_stability_relations`.`less_stable` AND NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `replaced_binary_packages_copy`
 	WHERE `replaced_binary_packages_copy`.`id`=`prov_bp`.`id`)) AND NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `install_target_providers`
 	JOIN `moveable_binary_packages_copy`
 	ON `moveable_binary_packages_copy`.`id`=`install_target_providers`.`package`
@@ -176,7 +176,7 @@ DELETE `replaced_binary_packages`,`moveable_binary_packages`
 	ON `repl_bp`.`id`=`install_target_providers`.`package`
 	JOIN `dependencies`
 	ON `install_target_providers`.`install_target`=`dependencies`.`depending_on` AND NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `replaced_binary_packages_copy`
 	WHERE `replaced_binary_packages_copy`.`id`=`dependencies`.`dependent`)
 	JOIN `dependency_types`
@@ -190,12 +190,12 @@ SELECT *
 	JOIN `repository_stability_relations` AS `repl_rr`
 	ON `repl_rr`.`more_stable`=`repl_r`.`stability` AND `repl_rr`.`less_stable`=`req_r`.`stability`
 	WHERE NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `moveable_binary_packages_copy`
 	JOIN `install_target_providers` AS `subst_itp`
 	ON `moveable_binary_packages_copy`.`id`=`subst_itp`.`package`
 	WHERE `subst_itp`.`install_target`=`install_target_providers`.`install_target`) AND NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `binary_packages` AS `subst_bp`
 	JOIN `install_target_providers` AS `subst_itp`
 	ON `subst_bp`.`id`=`subst_itp`.`package`
@@ -204,7 +204,7 @@ SELECT *
 	JOIN `repository_stability_relations` AS `subst_rr`
 	ON `subst_rr`.`more_stable`=`subst_r`.`stability`
 	WHERE `subst_rr`.`less_stable`=`repl_r`.`stability` AND NOT EXISTS (
-SELECT *
+SELECT 1
 	FROM `replaced_binary_packages_copy2`
 	WHERE `replaced_binary_packages_copy2`.`id`=`subst_bp`.`id`) AND `subst_itp`.`install_target`=`install_target_providers`.`install_target`);
 SET row_count_saved = row_count_saved + ROW_COUNT();