Invention Grant
- Patent Title: Regression testing of SQL execution plans for SQL statements
-
Application No.: US15089773Application Date: 2016-04-04
-
Publication No.: US09990275B2Publication Date: 2018-06-05
- Inventor: Jonathan M. Harding
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Cuenot, Forsythe & Kim, LLC
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F11/36

Abstract:
A first execution plan for a first version of a structured query language statement can be requested from a database management system. The first execution plan for the first version of the structured query language statement can be loaded into a first directed graph tree structure comprising a plurality of nodes. The first directed graph tree structure can be scanned to determine whether a full table scan for accessing requested data is represented by at least a one of the plurality of nodes of the directed graph tree structure. Responsive to determining that the full table scan for accessing the requested data is represented by the at least one of the plurality of nodes of the directed graph tree structure, a first indicator that indicates a fault condition can be output.
Public/Granted literature
- US20160217065A1 REGRESSION TESTING OF SQL EXECUTION PLANS FOR SQL STATEMENTS Public/Granted day:2016-07-28
Information query