with recursive ps(product_code,description,parent_id) as (select product_code,description,parent_id from product_code where parent_id='cp' union all select b.product_code,b.product_code,ps.parent_id from ps,product_code b where ps.parent_id=b.product_code) select * from ps |
See: SQLCODE -923 "Too many recursive iterations". You have exceeded the maximum recursion level of the server, set by max_recursive_iterations. You have numerous errors in your recursive SQL query:
Here is the SQL: with recursive ps(product_code,description,parent_id) as (select product_code,description,parent_id from product_code where product_code='cp' union all select b.product_code,b.description,b.parent_id from ps,product_code b where ps.product_code=b.parent_id) select * from ps |
To add to Jeff's explanation: Furthermore it might not be clear that the recursive query (i.e. the "select b.product_code, ... where ps.product_code=b.parent_id") has a limitation itself - the error given usually does come up when the recursion enters a loop, that is when the same rows will be added again and again... IMHO, that will happen here as there is no WHERE clause that prevents another joined row from ps x b to be added recursively to ps... |