Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
- Need a hierarachy analyzer that show the Procedure/Function/Event calling stack.
- For example, when a ViewA uses/calls TableA, View1, View2, and View1 calls View1_1, View1_2 and so on. By one command, wanna see the all the call stack hierarachy like:
case A
no|parent | child
1, ViewA, TableA
2, ViewA, View1
3, ViewA, View2
4, View1, View1_1
5, View1, View1_2
or
case B.
ViewA
----- TableA
----- View1
----- View2
----- View1_1
----- View1_2
- Need exception breaker the infinite loop by using the config 'max_recursive_iterations', and produce error message that recursive loop problem.
The reason why is that,
in these days DB business logic is so complex and hard, even painful to manually/humanly trace all the continuely changed code.
So, like the command 'EXPLAIN', provide a command to analyze call stack hierarachy since need to trace 15~10 depth calling stack manually.