Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.6, 10.7, 10.8
-
Component/s: Data Definition - Create Table, Server
-
Labels: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
-