Mutating database queries

J Tuya, MJ Suárez-Cabal, C De La Riva - Information and Software …, 2007 - Elsevier
Information and Software Technology, 2007Elsevier
A set of mutation operators for SQL queries that retrieve information from a database is
developed and tested against a set of queries drawn from the NIST SQL Conformance Test
Suite. The mutation operators cover a wide spectrum of SQL features, including the handling
of null values. Additional experiments are performed to explore whether the cost of
executing mutants can be reduced using selective mutation or the test suite size can be
reduced by using an appropriate ordering of the mutants. The SQL mutation approach can …
A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, including the handling of null values. Additional experiments are performed to explore whether the cost of executing mutants can be reduced using selective mutation or the test suite size can be reduced by using an appropriate ordering of the mutants. The SQL mutation approach can be helpful in assessing the adequacy of database test cases and their development, and as a tool for systematically injecting faults in order to compare different database testing techniques.
Elsevier