Bug #48595 the function inet_ntoa delivers a wrong value if IP is IPv6 like "::1".
Submitted: 6 Nov 2009 8:52 Modified: 6 Nov 2009 19:02
Reporter: Horst Hunger Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:6.0-codebase OS:Any
Assigned to: CPU Architecture:Any

[6 Nov 2009 8:52] Horst Hunger
Description:
The following statement gives back a wrong value:

SELECT inet_ntoa('::1');
inet_ntoa('::1')
0.0.0.0

With IPv4 it works well.

How to repeat:
set "--skip-name-resolve",
execute the statement with mtr or mysql.
[6 Nov 2009 11:55] MySQL Verification Team
Thank you for the bug report. Verified as described.
[6 Nov 2009 18:43] Davi Arnaut
IPv6 addresses aren't represented in dotted-quad format.
[6 Nov 2009 19:02] Valeriy Kravchuk
Duplicate of Bug #34037.