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