[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] 2 commits: reproducible Debian: fixup sql

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
e650a5ee by Holger Levsen at 2020-02-27T02:47:09+01:00
reproducible Debian: fixup sql

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -
8b9eecf3 by Holger Levsen at 2020-02-27T02:49:16+01:00
reproducible Debian: fixup SQL capitalisation

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/reproducible_html_builtin-pho.sh


Changes:

=====================================
bin/reproducible_html_builtin-pho.sh
=====================================
@@ -24,20 +24,20 @@ query_builtin_pho_db() {
 	fi
  
 	psql buildinfo <<EOF > $DUMMY_FILE
-select distinct p.source,p.version
-from
+SELECT DISTINCT p.source,p.version
+FROM
       binary_packages p
-where
+WHERE
       p.suite='$SUITE'
-except
-        select p.source,p.version
-from binary_packages p, builds b
-where
+EXCEPT
+      SELECT p.source,p.version
+FROM binary_packages p, builds b
+WHERE
       b.source=p.source
-      and p.version=b.version
-      and ( (b.arch_all and p.arch='all') or
-            (b.arch_$ARCH and p.arch='$ARCH') )
-order by p.source
+      AND p.version=b.version
+      AND ( (b.arch_all AND p.arch='all') OR
+            (b.arch_$ARCH AND p.arch='$ARCH') )
+ORDER BY source
 EOF
 }
 



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/12a55ac3c23a6df2375d71454010787fa46385a2...8b9eecf390bf29810df60a2085bdfaa167737c0e

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/12a55ac3c23a6df2375d71454010787fa46385a2...8b9eecf390bf29810df60a2085bdfaa167737c0e
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20200227/b8c109ec/attachment-0001.html>