Debugging for SQL statement
AssigneeInternational Business Machines Corporation
InventorsShuo Li, Xin Peng Liu, Xiaobo Wang, Xiong Wei Zhao
Life of this patent
Estimating the term…
Abstract
This disclosure provides a computer-implemented method for debugging a program including a SQL statement. The method comprises indicating one or more first positions of source code of the program. Each of the one or more first positions corresponds to a fragment of the SQL statement at which a breakpoint can be set. The method further comprises receiving an input of setting breakpoint at one of the one or more first positions. The method further comprises presenting an execution context generated in response to execution of the program reaching a breakpoint set based on the input.
Claims20
A computer-implemented method for debugging a program including a Structured Query Language (SQL) statement, the method comprising:
- indicating one or more first positions of a source code of a program, wherein each of the one or more first positions corresponds to a fragment of a SQL statement at which a breakpoint can be set, and a sub-query is considered a fragment, wherein when a user moves a cursor over a fragment at which the breakpoint can be set, the movement of the cursor over the fragment will cause a bubble or a window to open to prompt the user that a break point can be set, wherein the fragment of the SQL statement refers to a part of the SQL statement, such as including a clause, an equation or a variable in the SQL statement;
- receiving an input of the setting breakpoint at one of the one or more first positions;
- and
- presenting an execution context generated in response to execution of the program reaching the breakpoint set based on the input.
A system for debugging a program including a Structured Query Language (SQL) statement, comprising:
- one or more processors;
- a memory coupled to at least one of the one or more processors;
- a set of computer program instructions stored in the memory and executed by at least one of the one or more processors in order to perform actions of:
- indicating one or more first positions of source code of a program, wherein each of the one or more first positions corresponds to a fragment of the SQL statement at which a breakpoint can be set, and a sub-query is considered a fragment, wherein when a user moves a cursor over a fragment at which the breakpoint can be set, the movement of the cursor over the fragment will cause a bubble or a window to open to prompt the user that a break point can be set, wherein the fragment of the SQL statement refers to a part of the SQL statement, including a clause, an equation or a variable in the SQL statement;
- receiving an input of setting breakpoint at one of the one or more first positions;
- and
- presenting an execution context generated in response to execution of the program reaching a breakpoint set based on the input.
A computer program product for debugging a program including a SQL statement, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the program instructions being executable by a device to perform a method comprising:
- indicating one or more first positions of source code of the program, wherein each of the one or more first positions corresponds to a fragment of the SQL statement at which a breakpoint can be set, and a sub-query is considered a fragment, wherein when a user moves a cursor over a fragment at which the breakpoint can be set, the movement of the cursor over the fragment will cause a bubble or a window to open to prompt the user that a break point can be set, wherein the fragment of the SQL statement refers to a part of the SQL statement, including a clause, an equation or a variable in the SQL statement;
- receiving an input of setting breakpoint at one of the one or more first positions;
- and
- presenting an execution context generated in response to execution of the program reaching a breakpoint set based on the input.
Dependencies are inferred from the claim text.