Patent ID: 8775412

Claim:
A method for automatic handling of errors within a database engine, the method comprising the steps of: detecting an error while executing a query access plan, wherein the error is an execution error of a type that halts execution of the query access plan, wherein the query access plan is of the type generated by a query optimizer, wherein the query access plan is generated prior to installation of a patch to at least one of the database engine and the query optimizer, wherein the patch comprises a program fix including executable code that modifies at least one of the database engine and the query optimizer, and wherein detecting the error is performed after installation of the patch; in response to detecting the error, automatically rebuilding the query access plan with the query optimizer to generate a new query access plan, wherein the new query access plan is generated after installation of the patch; and executing the new query access plan to generate at least a portion of a result set for storage or display.