Bug #93786 SHOW BINLOG EVENTS FROM <bad offset> is not diagnosed for 1-3 and invalid offset
Submitted: 2 Jan 16:42 Modified: 3 Jan 6:33
Reporter: Przemysław Skibiński (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.7.24, 8.0.13 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[2 Jan 16:42] Przemysław Skibiński
Description:
There is no ER_ERROR_WHEN_EXECUTING_COMMAND error for invalid offsets:
SHOW BINLOG EVENTS FROM 1
SHOW BINLOG EVENTS FROM 2
SHOW BINLOG EVENTS FROM 3
and
SHOW BINLOG EVENTS FROM $binlog_end_pos+1
defined as
--let $binlog_end_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
--inc $binlog_end_pos
--eval SHOW BINLOG EVENTS FROM $binlog_end_pos

How to repeat:
Use attached MTR test.
[2 Jan 16:44] Przemysław Skibiński
MTR test to verify the bug

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: show_binlog_events.test (application/octet-stream, text), 1.77 KiB.

[3 Jan 6:33] Umesh Shastry
Hello Przemysław,

Thank you for the report and contribution.

regards,
Umesh