An Algorithm aiding in SQL Diagnosis
Original Publication Date: 2003-Jul-15
Included in the Prior Art Database: 2003-Jul-15
A recurring problem in daily DBMS operation, is the failure of SQL due to bad data from the source table. Small changes in the semantic meaning of a column or NLS characters may result in an unexpected SQL statement failure. This paper describes an algorithm for diagnosing SQL failures in an autromated fashion using combinatorial methods on the predicates in the WHERE clauses of each SELECT statement in the SQL statement.