I try to use pt-query-digest version 3.0.3 for save queries from slow in mysql using function --review.
After pt-query-digest analyzed slow.log file with very long query and put it to db/review table, then make
SQL request "SELECT sample from query;" i got only part of very long request finished at '280788', '543436', '25760', '102092', '53947', '398066', '165905', '358762', '146480', '167429', '108590', '659041', '352966', '41082', '539416', '166070', '536148', '145889', '309654', '168230', '145889', '145637', '143462', '
pt-query-digest --user root --ask-pass --create-review-table --review h=localhost,D=slow_log,t=query --report-format query_report --type slowlog log.txt
In attachment have sample of slow log, and You can try it by self for check.
Reproduced with 3.0.3:
pt-query-digest --create-
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: Data too long for column 'sample' at row 1 [for Statement " INSERT INTO `percona`.`review1`
Expected behavior: correct truncate (e.g. '301656'/*... omitted 8781 items ...*/ ) or change sample field type to longtext.
Workaround:
alter table review modify column sample longtext;