summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKarsten Loesing <karsten.loesing@gmx.net>2018-08-31 08:40:29 +0200
committerKarsten Loesing <karsten.loesing@gmx.net>2018-08-31 08:40:29 +0200
commit2cb74cd9bb6858b5442442f70667cdf5db75013f (patch)
tree4eb58059a12c4b153f7fd9d894a7d522081912e4
parent8159855b178dfc00c8634d898322db722cd7fa27 (diff)
squash! Reduce database size and variance of query response times.
- Use := rather than = for assignments, for consistency.
-rwxr-xr-xsrc/main/sql/exonerator2.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/main/sql/exonerator2.sql b/src/main/sql/exonerator2.sql
index 6643a2b..91682e6 100755
--- a/src/main/sql/exonerator2.sql
+++ b/src/main/sql/exonerator2.sql
@@ -410,8 +410,8 @@ BEGIN
OR last_date IS NULL OR DATE(rec.validafter) != last_date THEN
PERFORM insert_date_address24(DATE(rec.validafter), oraddress24,
last_fingerprint_id);
- last_address24 = oraddress24;
- last_date = DATE(rec.validafter);
+ last_address24 := oraddress24;
+ last_date := DATE(rec.validafter);
END IF;
last_nickname := matches[1];
last_fingerprint_base64 := matches[2];
@@ -448,8 +448,8 @@ BEGIN
OR last_date IS NULL OR DATE(rec.scanned) != last_date THEN
PERFORM insert_date_address24(DATE(rec.scanned), rec.exitaddress24,
last_fingerprint_id);
- last_address24 = rec.exitaddress24;
- last_date = DATE(rec.scanned);
+ last_address24 := rec.exitaddress24;
+ last_date := DATE(rec.scanned);
END IF;
last_fingerprint_base64 := fingerprint_base64;
copied_rows := copied_rows + 1;