ACM SIGMOD Record
Is mutation an appropriate tool for testing experiments?
Proceedings of the 27th international conference on Software engineering
Semantic errors in SQL queries: A quite complete list
Journal of Systems and Software - Special issue: Quality software
Information and Software Technology
SQLMutation: A tool to generate mutants of SQL database queries
MUTATION '06 Proceedings of the Second Workshop on Mutation Analysis
Sufficient mutation operators for measuring test effectiveness
Proceedings of the 30th international conference on Software engineering
Hi-index | 0.00 |
Mutation testing involves systematically generating and introducing faults into an application to improve testing. A quasi-experimental study is reported comparing the fault-detection capabilities of real-world database application test suites to those of an SQL vendor test suite (NIST SQL) based on mutation scores. The higher the mutation score the more successful the test suite will be at detecting faults. The SQLMutation tool was used to generate query mutants from beginner-level sample schemas obtained from three popular real-world database test suite vendors -- MySQL, SQL Server, and Oracle. Four SQLMutation operators were applied to both real-world and NIST SQL vendor compliance test suites - SQL Clause (SC), Operator Replacement (OR), NULL (NL) and Identifier Replacement (IR). Two mutation operators, SC and NL generated significantly lower mutation scores in real-world test suites than for those in the vendor test suite. The IR operator generated significantly higher mutation scores in real-world test suites than for those in the vendor test suite. The OR operator produced roughly the same mutation scores in both the real-world and vendor test suites.