When using the MS SQL Server Plus Plugin, when performing a nslookup for a record that exists as a CNAME record, the resulting IP addresses come back as a duplicate. I think this is a bug. Not using the SQL plugin produces different results.
To verify, I hard-coded the following SQL Statement for the SQL Plus plugin:
SELECT 'www.ryan.com' as RecData, 'testing.ryan.com' as RecName, 'CNAME' as RecType
SELECT '18.104.22.168' as RecData, 'www.ryan.com' as RecName, 'A' as RecType
which produces the following SQL results:
RecData | RecName | RecType
www.ryan.com | testing.ryan.com | CNAME
22.214.171.124 | www.ryan.com | A
However, I get this when using nslookup when the SQL Plugin is configured with the above SQL Statement. (nslookup has set type=A, attempting to resolve 'testing.ryan.com'):
The bug is that the IP address is listed twice, and it should only be listed once.
When configuring the exact same CNAME record ('testing.ryan.com') and the exact same corresponding A record ('www.ryan.com') directly within a SimpleDNS zone (that is, a local zone not using SQL plugin), I get this:
Note that the IP address here is correctly listed only once, as there is only one A record for 'www'.
Can you please confirm if this is a bug?
== ALSO ==
For matching CNAMEs discovered to exist when a DNS query is performed for an A record, does the SQL Statement for the plugin need to return data in different format than what is shown by the SQL Statement above? If so, what is SimpleDNS expecting in the SQL results for A record queries with CNAMEs?