From 1d8c2701306e559244011efec8827816e450788b Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Thu, 18 Oct 2012 11:13:40 +0300 Subject: [PATCH] Fix compare expression - md5() was in wrong place --- python/londiste/compare.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/python/londiste/compare.py b/python/londiste/compare.py index f2d253ab..067a6b49 100644 --- a/python/londiste/compare.py +++ b/python/londiste/compare.py @@ -36,7 +36,7 @@ class Comparator(Syncer): v1 = src_db.server_version v2 = dst_db.server_version if (v1 < 80400 or v2 < 80400) and v1 != v2: - q = "select count(1) as cnt, sum(md5('x'||substr(md5(_COLS_::text),1,16))::bit(64)::bigint) as chksum from only _TABLE_" + q = "select count(1) as cnt, sum(('x'||substr(md5(_COLS_::text),1,16))::bit(64)::bigint) as chksum from only _TABLE_" else: q = "select count(1) as cnt, sum(hashtext(_COLS_::text)::bigint) as chksum from only _TABLE_" -- 2.39.5