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

Testing Database Engines via Query Plan Guidance

  • 1. National University of Singapore


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 (140.3 MB)

Name Size Download all
140.3 MB Download

Additional details

Related works

Is supplement to
Conference paper: (URL)