Invention Grant
- Patent Title: Systems and methods for SQL value evaluation to detect evaluation flaws
-
Application No.: US15268510Application Date: 2016-09-16
-
Publication No.: US10025936B2Publication Date: 2018-07-17
- Inventor: Kunal Anand , Michael Crampon , Richard Meester , Joseph Rozner , Joshua Chase
- Applicant: Prevoty, Inc.
- Applicant Address: US CA Los Angeles
- Assignee: PREVOTY, INC.
- Current Assignee: PREVOTY, INC.
- Current Assignee Address: US CA Los Angeles
- Agent Kang S. Lim
- Main IPC: G06F21/57
- IPC: G06F21/57 ; G06F21/56 ; G06F17/30 ; G06F21/52

Abstract:
Methods and apparatuses for detecting an evaluation flaw in a SQL query, the SQL query configured to access data in a database table are disclosed. The method includes creating a parse tree from the SQL query and evaluating the parse tree to ascertain whether a condition of the SQL query results in a type or value that is independent of contents of the database table. For type evaluation, if, responsive to the evaluating, the condition is found, designating the SQL query at risk for having the tautology in the SQL query. For value evaluation, if, responsive to the evaluating, the condition is found, determining whether the condition is always true or whether the condition is always false; and if, responsive to the determining, the condition is found to be always true or always false, designating the SQL query at risk for having the evaluation flaw in the SQL query.
Public/Granted literature
- US20170068820A1 SYSTEMS AND METHODS FOR SQL VALUE EVALUATION TO DETECT EVALUATION FLAWS Public/Granted day:2017-03-09
Information query