Changeset 1040 for branches/cname-collision

Timestamp:

02/18/26 18:09:03 (32 hours ago)

Author:

Kris Deugau

Message:

/branches/cname-collision

Last-minute-ish addition of another block of tests to make sure non-CNAMEs
collide with CNAMEs, but continue to not collide with each other
First, the new domain and records
See #72, #88

Location:

branches/cname-collision/t

Files:

• dns-unitbase.sql (modified) (6 diffs)
• test-cname-timestamps.sql (modified) (1 diff)

branches/cname-collision/t/dns-unitbase.sql

@@ -660 +660 @@
 5       expiry2.test    1               1       2026011901      D       t       
 6       expiry3.test    1               1       2026020509      D       t       
+7       cname-blocks1.test      1               1       2026021811      D       t       
 \.
 
@@ -667 +668 @@
 --
 
-SELECT pg_catalog.setval('public.domains_domain_id_seq', 6, true);
+SELECT pg_catalog.setval('public.domains_domain_id_seq', 7, true);
 
 
@@ -823 +824 @@
 114     6       1       1       admin   Initial User    Added record 'validafter4b.expiry3.test TXT to change', TTL 5400        2026-02-05 17:17:09.60198-05    0       0
 115     6       1       1       admin   Initial User    Added record 'validafter5b.expiry3.test TXT to change', TTL 5400        2026-02-05 17:17:15.012334-05   0       0
+116     7       1       1       admin   Initial User    Added active domain cname-blocks1.test  2026-02-18 18:00:14.727439-05   0       0
+117     7       1       1       admin   Initial User    [new cname-blocks1.test] Added SOA record [contact ns1.example.com] [master hostmaster.cname-blocks1.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400        2026-02-18 18:00:14.727439-05   0       116
+118     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'cname-blocks1.test NS ns2.example.com', TTL 7200 2026-02-18 18:00:14.727439-05   0       116
+119     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'cname-blocks1.test NS ns1.example.com', TTL 7200 2026-02-18 18:00:14.727439-05   0       116
+120     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'cname-blocks1.test A 10.0.0.4', TTL 7200 2026-02-18 18:00:14.727439-05   0       116
+121     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'cname-blocks1.test MX [distance 10] mx1.example.com', TTL 7200   2026-02-18 18:00:14.727439-05   0       116
+122     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'www.cname-blocks1.test CNAME cname-blocks1.test', TTL 10800      2026-02-18 18:00:14.727439-05   0       116
+123     7       1       1       admin   Initial User    [new cname-blocks1.test] Added record 'cname-blocks1.test TXT "v=spf1 a mx -all"', TTL 10800    2026-02-18 18:00:14.727439-05   0       116
+124     7       1       1       admin   Initial User    Added record 'blocker01.cname-blocks1.test TXT I do not collide', TTL 5400      2026-02-18 18:00:35.918847-05   0       0
+125     7       1       1       admin   Initial User    Added record 'blocker02.cname-blocks1.test CNAME target.example.com', TTL 5400  2026-02-18 18:00:54.003589-05   0       0
+126     7       1       1       admin   Initial User    Added record 'blocker03.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05       2026-02-18 18:01:13.009519-05   0       0
+127     7       1       1       admin   Initial User    Added record 'blocker04.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05      2026-02-18 18:01:24.142491-05   0       0
+128     7       1       1       admin   Initial User    Added record 'blocker05.cname-blocks1.test CNAME target.example.com', TTL 5400  2026-02-18 18:02:22.263541-05   0       0
+129     7       1       1       admin   Initial User    Added record 'blocker06.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05       2026-02-18 18:02:37.418389-05   0       0
+130     7       1       1       admin   Initial User    Added record 'blocker07.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05      2026-02-18 18:02:47.023266-05   0       0
+131     7       1       1       admin   Initial User    Added record 'blocker08.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05      2026-02-18 18:02:52.405397-05   0       0
+132     7       1       1       admin   Initial User    Added record 'blocker09.cname-blocks1.test CNAME target.example.com', TTL 5400  2026-02-18 18:03:11.617403-05   0       0
+133     7       1       1       admin   Initial User    Added record 'blocker10.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05       2026-02-18 18:03:25.888935-05   0       0
+134     7       1       1       admin   Initial User    Added record 'blocker11.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05       2026-02-18 18:03:33.383937-05   0       0
+135     7       1       1       admin   Initial User    Added record 'blocker12.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05      2026-02-18 18:03:41.441495-05   0       0
 \.
 
@@ -830 +851 @@
 --
 
-SELECT pg_catalog.setval('public.log_log_id_seq', 115, true);
+SELECT pg_catalog.setval('public.log_log_id_seq', 135, true);
 
 
@@ -975 +996 @@
 6       103     validafter4b.expiry3.test       16      to change       0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
 6       104     validafter5b.expiry3.test       16      to change       0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       105     ns1.example.com:hostmaster.cname-blocks1.test   6       10800:3600:604800:5400  0       0       0       86400   \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       106     cname-blocks1.test      2       ns2.example.com 0       0       0       7200    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       107     cname-blocks1.test      2       ns1.example.com 0       0       0       7200    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       108     cname-blocks1.test      1       10.0.0.4        0       0       0       7200    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       109     cname-blocks1.test      15      mx1.example.com 10      0       0       7200    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       110     www.cname-blocks1.test  5       cname-blocks1.test      0       0       0       10800   \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       111     cname-blocks1.test      16      "v=spf1 a mx -all"      0       0       0       10800   \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       112     blocker01.cname-blocks1.test    16      I do not collide        0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       113     blocker02.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       114     blocker03.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  t       t       \N
+7       115     blocker04.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  f       t       \N
+7       116     blocker05.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       117     blocker06.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  t       t       \N
+7       118     blocker07.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  f       t       \N
+7       119     blocker08.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  f       t       \N
+7       120     blocker09.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               1969-12-31 19:00:00-05  f       f       \N
+7       121     blocker10.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  t       t       \N
+7       122     blocker11.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  t       t       \N
+7       123     blocker12.cname-blocks1.test    5       target.example.com      0       0       0       5400    \N      0               2026-02-20 20:20:00-05  f       t       \N
 \.
 
@@ -982 +1022 @@
 --
 
-SELECT pg_catalog.setval('public.records_record_id_seq', 104, true);
+SELECT pg_catalog.setval('public.records_record_id_seq', 123, true);
 
 

branches/cname-collision/t/test-cname-timestamps.sql

@@ -33 +33 @@
 UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 98;
 UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 99;
+
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 114;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 115;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 117;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 118;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 119;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 121;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 122;
+UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 123;