Database entries
domain_id name type content
55392 domain.nl SOA nsa.byte.nl. hostmaster.byte.nl. 2003030410
55392 domain.nl NS nsa.byte.nl
55392 domain.nl NS nsb.byte.nl
55392 domain.nl NS nsc.byte.nl
55392 domain.nl A 46.21.227.210
55392 *.domain.nl A 46.21.227.210
55392 sub.domain.nl A 46.21.227.210
To be clear, for sub.domain.nl there is a record, for bla.domain.nl not.
PowerDNS 2.9
;; ANSWER SECTION:
bla.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
www.bla.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
sub.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
www.sub.domain.nl. 600 IN A 46.21.227.210
PowerDNS 3.3.1
;; ANSWER SECTION:
bla.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
www.bla.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
sub.domain.nl. 600 IN A 46.21.227.210
;; ANSWER SECTION:
www.sub.domain.nl. 600 IN A
Corresponding DB queries for 3.3.1:
select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='domain.nl'
select content,ttl,prio,type,domain_id,name from records where type='NS' and name='www.sub.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where type='NS' and name='sub.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='www.sub.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='*.sub.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='sub.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='www.bla.domain.nl'
select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='bla.domain.nl'
select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='domain.nl'
select content,ttl,prio,type,domain_id,name from records where type='NS' and name='www.bla.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where type='NS' and name='bla.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='www.bla.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='*.bla.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='bla.domain.nl' and domain_id=55392
select content,ttl,prio,type,domain_id,name from records where name='*.domain.nl' and domain_id=55392
Possibly related: http://mailman.powerdns.com/pipermail/pdns-users/2012-December/009513.html