Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Fix Version/s: N/A
-
Component/s: OTHER
-
Labels:
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.