[MDEV-13962] Bug: WITH Table Statements Interfere Between Them Created: 2017-09-29  Updated: 2017-09-29  Resolved: 2017-09-29

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Juan Telleria Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: 10.2


 Description   

When I create a statement of the type:

WITH t_aux
 
AS
 
(
 
 
 
)
 
SELECT
 
   *
 
FROM
 
   t_aux;

It interferes the temporary table created in the first WITH in the next one:

WITH t_aux_dummy
 
AS
 
(
 
 
 
)
 
SELECT
 
   *
 
FROM
 
   t_aux;

I understand that with WITH statement, created temporary tables shall be SELECT query specific.

 Comments   
Comment by Juan Telleria [ 2017-09-29 ]

This is not a bug and does not happen, I double checked it, and there is isolation between SELECT queries.

It is a wrong bug report, sorry.

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