Patent Document ID: 10025936
Application ID: 15268510

Base Claim:
1. A method for detecting an evaluation flaw in a SQL query, said SQL query configured to access data in a database table, comprising: creating a parse tree from said SQL query; evaluating said parse tree to ascertain whether a condition of said SQL query results in a value that is independent of contents of said database table, wherein said evaluating said parse tree further including storing a value of a select list element for subsequent expression evaluation; performing said subsequent expression evaluation when said select list element is a part of a sub-query; when, responsive to said evaluating, said condition is found, determining whether said condition is always true or whether said condition is always false; when, responsive to said determining, said condition is found to be always true or always false, designating said SQL query at risk for having said evaluation flaw in said SQL query: and rewriting the SQL query to avoid repeated performance of the condition.

---

Claim 6:
6. The method of claim 1 , further comprising when said condition is found to be always true or always false, preventing said SQL query from executing.