Bug Report: CREATE TEMPORARY TABLE ... AS (SELECT ... ) prints a warning in the Vitess log while it just works

[mcrauwel]

Overview of the Issue

I noticed this in the Vitess logs

W0318 15:28:05.312131       1 parser.go:85] ignoring error parsing DDL 'CREATE TEMPORARY TABLE it_departments AS (SELECT dept_no, dept_name FROM departments WHERE dept_no IN ('d005', 'd008'))': syntax error at position 41 near 'AS'
W0318 15:28:05.312894       1 parser.go:85] ignoring error parsing DDL 'CREATE TEMPORARY TABLE it_departments AS (SELECT dept_no, dept_name FROM departments WHERE dept_no IN ('d005', 'd008'))': syntax error at position 41 near 'AS'
W0318 15:28:05.313626       1 parser.go:85] ignoring error parsing DDL 'CREATE TEMPORARY TABLE it_departments AS (SELECT dept_no, dept_name FROM departments WHERE dept_no IN ('d005', 'd008'))': syntax error at position 41 near 'AS'
W0318 15:28:05.315061       1 parser.go:85] ignoring error parsing DDL 'CREATE TEMPORARY TABLE it_departments AS (SELECT dept_no, dept_name FROM departments WHERE dept_no IN ('d005', 'd008'))': syntax error at position 41 near 'AS'

Reproduction Steps

mysql> SELECT * FROM departments;
+---------+--------------------+
| dept_no | dept_name          |
+---------+--------------------+
| d009    | Customer Service   |
| d005    | Development        |
| d002    | Finance            |
| d003    | Human Resources    |
| d001    | Marketing          |
| d004    | Production         |
| d006    | Quality Management |
| d008    | Research           |
| d007    | Sales              |
+---------+--------------------+
9 rows in set (0.12 sec)

mysql> CREATE TEMPORARY TABLE it_departments AS (SELECT dept_no, dept_name FROM departments WHERE dept_no IN ('d005', 'd008'));
Query OK, 2 rows affected (0.12 sec)

mysql> SHOW CREATE TABLE it_departments\G
*************************** 1. row ***************************
       Table: it_departments
Create Table: CREATE TEMPORARY TABLE `it_departments` (
  `dept_no` char(4) NOT NULL,
  `dept_name` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.12 sec)

mysql> SELECT * FROM it_departments;
+---------+-------------+
| dept_no | dept_name   |
+---------+-------------+
| d005    | Development |
| d008    | Research    |
+---------+-------------+
2 rows in set (0.12 sec)

mysql> SELECT @@version;
+---------------+
| @@version     |
+---------------+
| 8.0.34-Vitess |
+---------------+
1 row in set (0.11 sec)

Binary Version

vttablet version Version: 21.0.0-SNAPSHOT (Git revision 32de268d18b4cb5ae1188d240134d3720b375ccd branch 'latest-21.0') built on Wed Feb 19 05:04:48 UTC 2025 by vitess@buildkitsandbox using go1.23.6 linux/amd64

Operating System and Environment details

Linux/amd64 - Ubuntu

Log Fragments