EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction

Summary: EPSC differentially tests DBMSs by comparing equivalent ordinary and prepared SQL, exposing logic bugs via result inconsistencies. Evaluation across seven mature systems found 52 unique bugs, including cases missed by prior techniques. (summarized by gpt-5.6-luna on Jul 26 2026)

Paper ID: 7426
Venue: SIGMOD
Year: 2026
Pagerank: 5.093636e-05
Overall Rank: 10,235 | 29.78%
DOI: 10.1145/3802053

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Chi Zhang (Tsinghua University)
2. Jie Liang (Beihang University)
3. Zhiyong Wu (Tsinghua University)
4. Dalong Shi (AVIC International Digital Network Technology Co., Ltd.)
5. Linzhang Wang (Nanjing University)
6. Yu Jiang (Tsinghua University)

BibTeX Citation

@inproceedings{zhang_sigmod26,
        title = {{EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction}},
        author = {Zhang, Chi and Liang, Jie and Wu, Zhiyong and Shi, Dalong and Wang, Linzhang and Jiang, Yu},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3802053},
        url = {https://dl.acm.org/doi/10.1145/3802053},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
208	CockroachDB: The Resilient Geo-Distributed SQL Database	2020	SIGMOD	0.00024968157
271	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00022703024
392	Massive Stochastic Testing of SQL	1998	VLDB	0.00019342814
734	QAGen: Generating Query-Aware Test Databases	2007	SIGMOD	0.00014525584
894	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013367658
2,044	Detecting Logic Bugs of Join Optimizations in DBMS	2023	SIGMOD	9.2663577e-05
3,513	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD	7.354613e-05
3,903	Keep It Simple: Testing Databases via Differential Query Plans	2024	SIGMOD	7.0304586e-05
5,281	Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees	2017	SIGMOD	6.2842378e-05
5,284	SQLite: Past, Present, and Future	2022	VLDB	6.2827906e-05
5,394	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB	6.2336084e-05
7,223	Dynamic Plan Generation for Parameterized Queries	2009	SIGMOD	5.6676987e-05
7,427	Constant Optimization Driven Database System Testing	2025	SIGMOD	5.620674e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,402	SRS: Detecting Logic Bugs of Join Implementation in DBMSs via Set Relation Synthesis	2026	SIGMOD
2	10,243	Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction	2026	SIGMOD
3	8,482	A Demonstration of DLBD: Database Logic Bug Detection System	2023	VLDB
4	10,216	DBugScribe: Automatic Database Bug Reproduction from Community Reports	2026	SIGMOD
5	10,477	One DBMS, Two Modes, and a Bunch of Bugs: Catching Logic Bugs in Distributed DBMSs via Differential Testing	2026	SIGMOD
6	5,429	Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction	2024	VLDB
7	2,044	Detecting Logic Bugs of Join Optimizations in DBMS	2023	SIGMOD
8	7,427	Constant Optimization Driven Database System Testing	2025	SIGMOD
9	9,227	Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction	2025	VLDB
10	10,358	Detecting Logic Bugs in DBMSs via Equivalent Data Construction	2026	SIGMOD