Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.1.25, 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
Engine CONNECT doesn't escape table name when autodetecting table structure for TABLE_TYPE=MYSQL using SHOW columns FROM source_table.
That means that following query fails:
CREATE TABLE new_table ENGINE=CONNECT TABLE_TYPE=MYSQL CONNECTION='mysql://user:pass@hostname/db_name/85e3adc9789111e7960b00163e6c8245' |
Escaping table name within the CREATE doesn't help. The CREATE works, but the engine retrieves data using invalid double escaped query
SELECT * FROM ``85e3adc9789111e7960b00163e6c8245``. |
The create works fine with explicit definition of columns.