Bug #102551 Update query value will not reflect in slave if I use schemaname.tablename
Submitted: 10 Feb 2021 4:43 Modified: 11 Feb 2021 10:41
Reporter: Anil Moolya Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.22 OS:Windows (Microsoft Windows 10 Home Single Language)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[10 Feb 2021 4:43] Anil Moolya
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Anil Moolya\AppData\Roaming\MySQL\Workbench\log\wb.log]

In MySQL-workbench, when I am running First query on master ,replication works but when I use second query on master, replication does not work

First query
---------------
use schema;
update tableA set colA='xyz' where id=1;

replication works.

second query
------------------------
update schema.tableA set colA='xyz' where id=1;

replication not works

it won't change value on slave. In short if I update using schema.tablename it won't reflect on slave but if I update using first query shown above it reflect on slave.This issue is on mysql-workbench.Any idea on this?

How to repeat:
run on master
-------------
use schema;
update tableA set colA='xyz' where id=1;

check on slave,valuereflects

run on master
------------------------
update schema.tableA set colA='xyz' where id=1;

check on slave,value not reflects
[11 Feb 2021 10:41] MySQL Verification Team
Hello Anil,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues at my end. 

Regards,
Ashwini Patil