pt-query-digest Pipeline process (aggregate fingerprint) caused an error due to "SET @@session.collation_database=DEFAULT/*!*/;" lines on binlog
Using the pt-query-digest tool from Percona percona-
with a binlog (binlog v 4) of 1 million lines from a MySQL server 5.1.54 it showed several errors like the following one
Pipeline process 11 (aggregate fingerprint) caused an error: Argument "default" isn't numeric in numeric gt (>) at (eval 38) line 6, <> line 6.
After showing 100 of this errors the pt-query-digest stopped, also with the option --continue-on-error
After debugging I found out that the errors were due to the following line that there was in the binlog
I'm attaching a short version of the binlog that causes just one error where I finally found that line in the binlog that caused the pt-query-digest error