Published January 20, 2023 | Version v1.1
Dataset Open

Testing Database Engines via Query Plan Guidance

  • 1. National University of Singapore

Description

This artifact is the supplementary material for the paper "Testing Database Engines via Query Plan Guidance" that is published in ICSE'23.

In the paper, we propose a new concept called Query Plan Guidance (QPG) for testing Database Management Systems (DBMSs). QPG tackles the test case generation problem by guiding test case generation towards exploring a variety of unique query plans. We found 50+ unique, previously-unknown bugs in SQLite, TiDB, and CockroachDB.

The prototype of QPG is a Java project, and we provide Dockerfiles to reproduce our three key empirical results.

Files

Files (140.3 MB)

Name Size Download all
md5:f0feb58dbfd8ec763e7dec3aab75ecdb
140.3 MB Download

Additional details

Related works

Is supplement to
Conference paper: http://jinshengba.me/assets/pdf/qpg_icse23.pdf (URL)