[Bug]: v4.3 - Sorting of DNS records is not correct/logical in forward zones

[michielvisser]

Describe the problem

When having the records in a zone sorted alphabetically, the sorting is not correct/logical both when in host-only and with full FQDNs.

When in Host only display, the @ (root) records are shown after the letter A:

When in full name mode (host only set to false), the root records are shown as domain name (which is correct-ish) but also then sorted and displayed in alphabetical order:

In both cases I would expect the root records (SOA, NS, any other records that is created on an '@') to be put on top of the list and the rest of the records should be sorted by the selected column.

This is on 4.3 branch latest commit as of writing this bug report.

Steps to reproduce

See bug description

Poweradmin version

4.3 branch

Database

MySQL

Additional information (optional)

No response

[edmondas]

Fix is queued for the patch release (probably this weekend) - please give it a try then and let me know if anything's still off. Thanks for the detailed report.

[michielvisser]

@edmondas Took me a couple of days before I was able to test. Forgot to mention in the bug report that I am using the API mode on 4.3. In API mode, the sorting of the records is still the same as before the fix with the root-records being sorted in the list als alphabetically.

Looking into the code changes, I think these fixes should work for SQL datbase mode, but not for API. But I might be mistaken here.