Bug #87659 ERROR 1406 (22001): Data too long for column 'result' at row 1
Submitted: 4 Sep 2017 16:38 Modified: 5 Sep 2017 16:03
Reporter: Shiv Iyer Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Firewall Severity:S3 (Non-critical)
Version: 5.7.19-enterprise-commercial-advanced OS:CentOS (CentOS Linux release 7.3.1611 (Core) )
Assigned to: CPU Architecture:Any

[4 Sep 2017 16:38] Shiv Iyer
Description:
The ERROR 1406 (22001): Data too long for column 'result' at row 1 while testing MySQL Enterprise Firewall following the documentation - https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html

mysql> CALL mysql.sp_set_firewall_mode('fwuser@localhost', 'PROTECTING');
ERROR 1406 (22001): Data too long for column 'result' at row 1

How to repeat:
Please follow the steps in the documentation  - https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html

Suggested fix:
Can we have default max_allowed_packet adjusted for the example in documentation ? I mean many use documentation for first time and the error is disappointing ...
[5 Sep 2017 16:01] MySQL Verification Team
Thanks,

Documentation team notified.

all best
Bogdan
[5 Sep 2017 16:03] Shiv Iyer
Thanks Bogdan !