pt-query-digest Pipeline process (aggregate fingerprint) caused an error due to "SET @@session.collation_database=DEFAULT/*!*/;" lines on binlog

[Lluis Carreras]

Using the pt-query-digest tool from Percona percona-toolkit-2.2.4 on Debian Linux 2.6.26-2-686
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
SET @@session.collation_database=DEFAULT/*!*/;

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

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1144