diff options
| author | Holger Levsen <holger@layer-acht.org> | 2015-09-07 22:37:22 +0200 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-09-07 22:37:22 +0200 |
| commit | c2b7f7f133105d0700cbda246bf368052b787d72 (patch) | |
| tree | 121de7a7f634a824f0b8b860b8d4d290e4bcacd8 | |
| parent | 39aacc2a488a81e3c93af57a9c3203e5cbffaaa1 (diff) | |
| download | jenkins.debian.net-c2b7f7f133105d0700cbda246bf368052b787d72.tar.xz | |
reproducible: capitalize SQL
| -rwxr-xr-x | bin/reproducible_common.sh | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index 9d4f9ce0..4ef4258f 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -513,9 +513,9 @@ create_png_from_table() { WHERE2_EXTRA="WHERE s.datum >= '2015-08-31'" fi sqlite3 -init ${INIT} --nullvalue 0 -csv ${PACKAGES_DB} "SELECT s.datum, - COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e where s.datum=e.datum and suite='testing' $WHERE_EXTRA),0) as 'reproducible_testing', - COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e where s.datum=e.datum and suite='unstable' $WHERE_EXTRA),0) as 'reproducible_unstable', - COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e where s.datum=e.datum and suite='experimental' $WHERE_EXTRA),0) as 'reproducible_experimental', + COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e WHERE s.datum=e.datum AND suite='testing' $WHERE_EXTRA),0) AS 'reproducible_testing', + COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e WHERE s.datum=e.datum AND suite='unstable' $WHERE_EXTRA),0) AS 'reproducible_unstable', + COALESCE((SELECT e.reproducible FROM stats_builds_per_day AS e WHERE s.datum=e.datum AND suite='experimental' $WHERE_EXTRA),0) AS 'reproducible_experimental', (SELECT e.unreproducible FROM stats_builds_per_day e WHERE s.datum=e.datum AND suite='testing' $WHERE_EXTRA) AS unreproducible_testing, (SELECT e.unreproducible FROM stats_builds_per_day e WHERE s.datum=e.datum AND suite='unstable' $WHERE_EXTRA) AS unreproducible_unstable, (SELECT e.unreproducible FROM stats_builds_per_day e WHERE s.datum=e.datum AND suite='experimental' $WHERE_EXTRA) AS unreproducible_experimental, |