Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
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.