Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
3.2.1
-
None
-
None
-
Yes
-
1
Description
I have attached a couple examples that when parsed with pt-query-digest will generate the following output:
buggy output:
{"classes":[{"attribute":"fingerprint","checksum":"C613002B5E02F1674B687C7FAF61088D",... where contact_id = 'Ã<?>\\\\¬^f<?>?<?>ä³Ãl\\\\½\\ order by created_at desc,...
non buggy:
{"classes":
[{"attribute":"fingerprint","checksum":"4770E236056DD53DC214129CD221A0B4"... where contact_id = ? order by created_at desc,...
It can be seen that on bugged version "contact_id" has a value, whereas on non bugged , parameter shown is "?".
Command used for parsing file is:
pt-query-digest --limit=0% --output json-anon --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"foo\"" buggy_example.txt > sample.out