Bug Report: Table names needing quotes are not handled correctly in mysqlctl schema manager

[dbussink]

Overview of the Issue

When you have a table that contains for example a ' in the name itself (yes, that's possible, you can put almost anything in a table name), the mysqlctl schema manager doesn't properly inspect this table. Specifically mysqlctl.GetColumns fails.

Reproduction Steps

Create a table with a quote:

mysql> create table `with ' quote` (i int);
Query OK, 0 rows affected (0.03 sec)

Use mysqlctl.GetColumns and see the error.

Binary Version

All supported versions including main

Operating System and Environment details

-

Log Fragments

Error transitioning to the desired state: REPLICA, Serving, will keep retrying: in Engine.reload(), reading table SHOW TABLES LIKE 'with : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'quote
                ORDER BY ORDINAL_POSITION' at line 3 (errno 1064) (sqlstate 42000) during query: SELECT COLUMN_NAME as column_name
                FROM INFORMATION_SCHEMA.COLUMNS
                WHERE TABLE_SCHEMA = 'some-db' AND TABLE_NAME = 'with ' quote
                ORDER BY ORDINAL_POSITION