Yuper Lay Myint, Hironori Washizaki, Yoshiaki Fukuzawa, Hideyuki Kanuka, Hiroki Ohbayashi, “Test case reduction based on the join condition in pairwise coverage-based database testing,” 5th International Workshop on Software Test Architecture (InSTA 2018), April 13, 2018, Västerås, Sweden, conjunction with ICST 2018

Testing database applications correctly and effectively remains an issue. This study improves Selected Pairwise Coverage Testing (SPCT), which is a pairwise coverage-based test method for database applications that can discover bugs not detected by conventional methods. Because SPCT considers only selected columns in the SQL query and the conditions in the simple WHERE clause, achieving full pairwise coverage has some redundancies. In this work, we propose a new pairwise coveragebased test method by considering the condition in the JOIN clause to further reduce the redundant parameter combinations. The experimental results are evaluated to confirm the effectiveness of proposed test method compared to SPCT.