Understanding and Reusing Test Suites Across Database Systems
Summary: Introduces SQuaLity, a unified test-suite uniting SQLite, PostgreSQL, and DuckDB to enable cross-DBMS test reuse. An empirical study shows wide variation in test formats and runner commands, plus dependencies and extensions, but cross-DBMS runs reveal crashes, hangs, and compatibility issues, highlighting both reuse barriers and benefits. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Suyang Zhong (National University of Singapore)
- 2. Manuel Rigger (National University of Singapore)
BibTeX Citation
@inproceedings{zhong_sigmod24,
title = {{Understanding and Reusing Test Suites Across Database Systems}},
author = {Zhong, Suyang and Rigger, Manuel},
series = {{SIGMOD} '24},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3698829},
url = {https://dl.acm.org/doi/10.1145/3698829},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,382 | Automated Database Testing via LLM-Synthesized SQL Features | 2027 | SIGMOD | 4.9605343e-05 |
| 10,510 | DBugScribe: Automatic Database Bug Reproduction from Community Reports | 2026 | SIGMOD | 4.9605343e-05 |
| 10,514 | Dialect-Agnostic SQL Parsing via LLM-Based Segmentation | 2026 | SIGMOD | 4.9605343e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023948467 |
| 71 | DuckDB: an Embeddable Analytical Database | 2019 | SIGMOD | 0.00037688945 |
| 378 | Massive Stochastic Testing of SQL | 1998 | VLDB | 0.000196128 |
| 1,103 | Elle: Inferring Isolation Anomalies from Experimental Observations | 2021 | VLDB | 0.00011969356 |
| 1,185 | Adaptive Optimization of Very Large Join Queries | 2018 | SIGMOD | 0.00011586181 |
| 1,436 | Towards a Learning Optimizer for Shared Clouds | 2019 | VLDB | 0.00010658836 |
| 1,765 | APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems | 2020 | VLDB | 9.689153e-05 |
| 1,800 | Procedural Extensions of SQL: Understanding their usage in the wild | 2021 | VLDB | 9.5999908e-05 |
| 1,854 | Detecting Logic Bugs of Join Optimizations in DBMS | 2023 | SIGMOD | 9.4858897e-05 |
| 3,705 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 7.0607226e-05 |
| 5,532 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 6.0779286e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 751 | QAGen: Generating Query-Aware Test Databases | 2007 | SIGMOD |
| 2 | 6,118 | Constant Optimization Driven Database System Testing | 2025 | SIGMOD |
| 3 | 4,127 | A genetic approach for random testing of database systems | 2007 | VLDB |
| 4 | 6,883 | Efficient Regression Tests for Database Applications | 2005 | CIDR |
| 5 | 7,658 | Test Data Generation for Complex SQL Queries | 2026 | SIGMOD |
| 6 | 5,261 | Test Data for Relational Queries (Extended abstract) | 1986 | PODS |
| 7 | 10,382 | Automated Database Testing via LLM-Synthesized SQL Features | 2027 | SIGMOD |
| 8 | 1,901 | Generating Targeted Queries for Database Testing | 2008 | SIGMOD |
| 9 | 7,221 | Semantic Conformance Testing of Relational DBMS | 2025 | VLDB |
| 10 | 9,252 | EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction | 2026 | SIGMOD |