Overview of the Issue
In #4727 , we implemented support for multiple databases w/ 1 mysql instance. There is 1 vttablet process per database. However, certain workflows don't work: MoveTables and Vdiff. I believe this is due to a missing WHERE db_name = ? clause in the relevant queries
Reproduction Steps
https://docs.google.com/document/d/18rWufcxguyRs8D9oy4NJHCdFkeaF9J2W5vXw3ovwhcY/edit?tab=t.0
Binary Version
% vttablet --version
vttablet version Version: 22.0.1 (Git revision 9ba5bcbce5dd300b8d10468e4d85d5a761386673 branch 'v22.0.1-2.etsy1') built on Wed Oct 22 21:34:32 UTC 2025 by root@10d6b2c0c66c using go1.24.4 linux/amd64
Operating System and Environment details
% cat /etc/os-release
PRETTY_NAME="Ubuntu 22.04.5 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.5 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=jammy
% uname -sr
Linux 6.8.0-1021-gcp
% uname -m
x86_64
Log Fragments
Overview of the Issue
In #4727 , we implemented support for multiple databases w/ 1 mysql instance. There is 1 vttablet process per database. However, certain workflows don't work: MoveTables and Vdiff. I believe this is due to a missing
WHERE db_name = ?clause in the relevant queriesReproduction Steps
https://docs.google.com/document/d/18rWufcxguyRs8D9oy4NJHCdFkeaF9J2W5vXw3ovwhcY/edit?tab=t.0
Binary Version
% vttablet --version vttablet version Version: 22.0.1 (Git revision 9ba5bcbce5dd300b8d10468e4d85d5a761386673 branch 'v22.0.1-2.etsy1') built on Wed Oct 22 21:34:32 UTC 2025 by root@10d6b2c0c66c using go1.24.4 linux/amd64Operating System and Environment details
Log Fragments