Wrong advise regarding IP-addresses
Bug #983191 reported by
Miguel Trias
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
Advise for query:
SELECT id,UNIX_
FROM some_table WHERE ip=INET_
incorrectly suggests that IP-numbers should be stored as integers, which is already the case.
The tools suggest conversion to integer by use of INET_ATON(), which is already present in the query.
To post a comment you must log in.
The new SQLParser.pm should make this easy to fix because it actually parses functions whereas older versions of the module did not.