The Community for Technology Leaders
2011 IEEE 27th International Conference on Data Engineering (2011)
Hannover, Germany
Apr. 11, 2011 to Apr. 16, 2011
ISBN: 978-1-4244-8959-6
pp: 1175-1186
Shetal Shah , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
S. Sudarshan , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
Suhas Kajbaje , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
Sandeep Patidar , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
Bhanu Pratap Gupta , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
Devang Vira , Computer Science and Engg. Dept., Indian Institute of Technology, Bombay, India
ABSTRACT
Complex SQL queries are widely used today, but it is rather difficult to check if a complex query has been written correctly. Formal verification based on comparing a specification with an implementation is not applicable, since SQL queries are essentially a specification without any implementation. Queries are usually checked by running them on sample datasets and checking that the correct result is returned; there is no guarantee that all possible errors are detected. In this paper, we address the problem of test data generation for checking correctness of SQL queries, based on the query mutation approach for modeling errors. Our presentation focuses in particular on a class of join/outer-join mutations, comparison operator mutations, and aggregation operation mutations, which are a common cause of error. To minimize human effort in testing, our techniques generate a test suite containing small and intuitive test datasets. The number of datasets generated, is linear in the size of the query, although the number of mutations in the class we consider is exponential. Under certain assumptions on constraints and query constructs, the test suite we generate is complete for a subclass of mutations that we define, i.e., it kills all non-equivalent mutations in this subclass.
INDEX TERMS
CITATION

S. Shah, B. P. Gupta, S. Patidar, S. Sudarshan, S. Kajbaje and D. Vira, "Generating test data for killing SQL mutants: A constraint-based approach," 2011 IEEE 27th International Conference on Data Engineering(ICDE), Hannover, Germany, 2011, pp. 1175-1186.
doi:10.1109/ICDE.2011.5767876
102 ms
(Ver 3.3 (11022016))