auto-data-snapshot: 2026-09-10T01:33:27 (1 data files) — scripts/merge-v2-into-canonical.sql

9ccba71b58d7041da1c62e166f480f7a8a10e476 · 2026-09-10 01:35:11 -0700 · auto-commit-fleet

Files touched

M scripts/merge-v2-into-canonical.sql

Diff

commit 9ccba71b58d7041da1c62e166f480f7a8a10e476
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Thu Sep 10 01:35:11 2026 -0700

    auto-data-snapshot: 2026-09-10T01:33:27 (1 data files) — scripts/merge-v2-into-canonical.sql
---
 scripts/merge-v2-into-canonical.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/scripts/merge-v2-into-canonical.sql b/scripts/merge-v2-into-canonical.sql
index 4b55c73..e1bb3e5 100644
--- a/scripts/merge-v2-into-canonical.sql
+++ b/scripts/merge-v2-into-canonical.sql
@@ -57,9 +57,9 @@ FROM _v2 v WHERE v.mkey NOT IN (SELECT mkey FROM _tgt);
 SELECT 'pre_rows'          lbl, n::text val FROM _pre
 UNION ALL SELECT 'pre_dwsku',       dwsku::text FROM _pre
 UNION ALL SELECT 'post_rows',       count(*)::text FROM _tgt
-UNION ALL SELECT 'post_dwsku',      count(dw_sku)::text FILTER (WHERE dw_sku<>'') FROM _tgt
-UNION ALL SELECT 'flagged_discont', count(*)::text FILTER (WHERE discontinued) FROM _tgt
-UNION ALL SELECT 'new_dwsku_null',  count(*)::text FILTER (WHERE dw_sku IS NULL) FROM _tgt
+UNION ALL SELECT 'post_dwsku',      (count(dw_sku) FILTER (WHERE dw_sku<>''))::text FROM _tgt
+UNION ALL SELECT 'flagged_discont', (count(*) FILTER (WHERE discontinued))::text FROM _tgt
+UNION ALL SELECT 'new_dwsku_null',  (count(*) FILTER (WHERE dw_sku IS NULL))::text FROM _tgt
 UNION ALL SELECT 'dupe_mkey',       (SELECT count(*)::text FROM (SELECT mkey FROM _tgt GROUP BY mkey HAVING count(*)>1) d);
 
 -- ASSERT: dw_sku preserved (post >= pre), no deletes (post_rows = pre + new)

← 9fa7d0c auto-data-snapshot: 2026-09-10T01:01:23 (1 data files) — scr · back to Newmor Onboard · TK-11346: Newmor metafield spec-backfill (gated dry-run) + r cde1d77 →