[#MDEV-16192] Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data

[MDEV-16192] Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data Created: 2018-05-16 Updated: 2018-07-18 Resolved: 2018-07-18
Status:	Closed
Project:	MariaDB Server
Component/s:	Data Definition - Temporary, Server
Affects Version/s:	10.2, 10.3
Fix Version/s:	10.2.17

Type:

Bug

Priority:

Major

Reporter:

Sachin Setiya (Inactive)

Assignee:

Andrei Elkin

Resolution:

Fixed

Votes:

Labels:

None

Environment:

All

Issue Links:

Duplicate
is duplicated by	~~MDEV-15867~~	Slave SQL: Error 'Table 't' is specif...	Closed

Description

CREATE TEMPORARY TABLE t (i INT);

CREATE or replace TABLE t AS SELECT * FROM t;

The last stmt will give error

ERROR 1093 (HY000): Table 't' is specified twice, both as a target for 'CREATE' and as a separate source for data

Comments

Comment by Sachin Setiya (Inactive) [ 2018-05-16 ]

Generated at Thu Feb 08 08:27:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.