diff options
| author | Karsten Loesing <karsten.loesing@gmx.net> | 2018-08-31 08:40:29 +0200 |
|---|---|---|
| committer | Karsten Loesing <karsten.loesing@gmx.net> | 2018-08-31 08:40:29 +0200 |
| commit | 2cb74cd9bb6858b5442442f70667cdf5db75013f (patch) | |
| tree | 4eb58059a12c4b153f7fd9d894a7d522081912e4 | |
| parent | 8159855b178dfc00c8634d898322db722cd7fa27 (diff) | |
squash! Reduce database size and variance of query response times.
- Use := rather than = for assignments, for consistency.
| -rwxr-xr-x | src/main/sql/exonerator2.sql | 8 |
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; |
