[MDEV-13463] Unescaped table name during detection of table structure - Jira

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.

Pavel Hadač created issue - 2017-08-07 10:51

Elena Stepanova made changes - 2017-08-07 11:26

Field	Original Value	New Value
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.	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: {code:sql} CREATE TABLE new_table ENGINE=CONNECT TABLE_TYPE=MYSQL CONNECTION='mysql://user:pass@hostname/db_name/85e3adc9789111e7960b00163e6c8245' {code} Escaping table name within the CREATE doesn't help. The CREATE works, but the engine retrieves data using invalid double escaped query {code:sql} SELECT * FROM ``85e3adc9789111e7960b00163e6c8245``. {code} The create works fine with explicit definition of columns.

Elena Stepanova made changes - 2017-08-07 12:16

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova made changes - 2017-08-07 12:19

Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.2 [ 14601 ]
Affects Version/s		10.0 [ 16000 ]
Affects Version/s		10.1 [ 16100 ]
Affects Version/s		10.2 [ 14601 ]
Assignee		Olivier Bertrand [ bertrandop ]

Julien Fritsch made changes - 2020-12-01 12:34

Fix Version/s

10.0 [ 16000 ]

Julien Fritsch made changes - 2020-12-01 12:40

Fix Version/s

10.1 [ 16100 ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 81926 ]

MariaDB v4 [ 143962 ]

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server