search

BenMorel / mysql-replication-check

A tool to checksum a MySQL slave against its master
MIT License
7 stars 1 forks source link

Missing quoteidentifier for database #2

Closed mokraemer closed 2 years ago

mokraemer commented 2 years ago

e.g. if the databasename contains "-"

the statement $statement = $master->query("SHOW FULL TABLES FROM $database WHERE Table_Type != 'VIEW'");

must be changed to $statement = $master->query("SHOW FULL TABLES FROM ".quoteIdentifier($database)." WHERE Table_Type != 'VIEW'");

mokraemer commented 2 years ago

bug2.txt

BenMorel commented 2 years ago

Thank you! Fixed in fe2dcabd78a67442bd2cebc95125dbafa9a9fa69.