STRUCTURED QUERY LANGUAGE DEBUGGER

摘要

The present disclosure describes methods, systems, and computer program products for debugging structured query language (SQL) statements. One computer-implemented method includes receiving a request to fetch a debug execution plan considering different structured query language (SQL) execution optimization levels and including a mapping for a SQL statement, receiving a request to initialize a debugging process of the SQL statement, verifying received and attached filter criteria provided using a SQL debug channel, setting SQL statement breakpoints, triggering the SQL statement, transmitting a notification that a SQL process is attached to a debugger associated and ready for external execution control, providing state details and an intermediate result upon reaching a particular breakpoint associated with the SQL process, providing an ability to change the process state and influence the process, and providing a SQL final execution response after reaching the end of the execution of the triggered SQL statement.

主权项

1. A computer-implemented method, comprising:
receiving a request to fetch a debug execution plan, the debug execution plan considering different structured query language (SQL) execution optimization levels and including a mapping for a SQL statement; receiving a request to initialize a debugging process of the SQL statement based on the debug execution plan; verifying received and attached filter criteria, the filter criteria provided using a SQL debug channel; setting breakpoints associated with the SQL statement; triggering the SQL statement; transmitting a notification that a SQL process associated with the triggered SQL statement is attached to a debugger associated with the debugging process and ready for external execution control; providing state details and an intermediate result upon reaching a particular breakpoint associated with the SQL process executing the triggered SQL statement; providing an ability to change the process state and influence the process; and providing a SQL final execution response after reaching the end of the execution of the triggered SQL statement.