Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1.2
-
None
-
None
-
Win64
Description
Sample query
WITH a AS (SELECT 5 mx) |
SELECT column_value FROM a,
|
(
|
WITH recursive r as
|
(SELECT 1 level |
union all
|
select LEVEL+1 FROM r |
)
|
select LEVEL column_value FROM r
|
) i
|
WHERE i.column_value<=a.mx
|
runs OK, but on insert or temporary table create:
CREATE OR REPLACE TEMPORARY TABLE tmp0 as
|
WITH a AS (SELECT 5 mx) |
SELECT column_value FROM a,
|
(
|
WITH recursive r as
|
(SELECT 1 level |
union all
|
select LEVEL+1 FROM r |
)
|
select LEVEL column_value FROM r
|
) i
|
WHERE i.column_value<=a.mx
|
it pops with error/warning "Query execution was interrupted. The query exceeded max_recursive_iterations = 100000. The query result may be incomplete".
I'd like to lose that unreasonable warning, just like it goes silent in select action. How can I do it?