[MDEV-7031] CREATE TEMPORARY TEMPORARY TEMPORARY TABLE Created: 2014-11-06  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.14
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

This weird syntax is supported in a mistake:

mysql> CREATE TEMPORARY TEMPORARY TEMPORARY TABLE t1 (a INT);
Query OK, 0 rows affected (0.15 sec)

More weird syntax:

CREATE TABLE t1 (a VARCHAR(10) CHARSET BINARY BINARY, b VARCHAR(10) BINARY CHARSET BINARY);



 Comments   
Comment by Ralf Gebhardt [ 2020-10-27 ]

With 10.5.6 the first query returns a syntax error, the second still results in

MariaDB [test]> show create table t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `a` varbinary(10) DEFAULT NULL,
  `b` varbinary(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Generated at Thu Feb 08 07:16:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.