Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
- It fails with quoted identifiers (exepcted output empty)
MariaDB [test]> CREATE TABLE `ab``c` (t1_id int PRIMARY KEY, t1_val varchar(10));
MariaDB [test]> show create table `ab``c`;
+-------+-------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------+
| ab`c | CREATE TABLE `ab``c` (
`i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+-------+-------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [test]> call sys.table_exists('test', '`ab``c`',@type);
ERROR 1103 (42000): Incorrect table name ''
- It even fails with valid table name (after removing enveloped and escaped backtick qoute) - expected output type of the table:
MariaDB [test]> call sys.table_exists('test','ab`c', @ext);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '` (id INT PRIMARY KEY)' at line 1
Attachments
Issue Links
- relates to
-
MDEV-28342 sys.create_synonym_db fails when a temporary table masks a base table
-
- Closed
-
Hi wlad can you please review https://github.com/MariaDB/server/commit/a2238dc96382a384071e7c93b2cc52bf260b0d6c