| |
- Causa
-
THE RECURSIVE COMMON TABLE EXPRESSION name MAY CONTAIN AN INFINITE LOOP
The recursive common table expression called name may not complete.
This warning is based on not finding specific syntax as part of the iterative portion of the recursive common table expression.
The expected syntax includes:
- incrementing an INTEGER column in the iterative select list by 1.
- a predicate in the where clause of the iterative portion of the form "counter_col < constant" or "counter_col < :hostvar".
The absence of this syntax in the recursive common table expression may result in an infinite loop.
The data or some other characteristic of the recursive common table expression may allow the successful completion of the statement anyway.
- Ação do sistema
-
The statement cannot be executed.
- Resposta ao Desenvolvedor
-
To prevent an infinite loop, include the expected syntax as described.
SQLSTATE: 01605
|
| |
