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
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 8.0.22
• OS: Windows (Microsoft Windows 10 Home Single Language)
• 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