Metraipolis › archive › dc_7d5f97ac3265

Detecting DBMS Bugs by Constructing Equivalent Representations of Intermediate Query Results — arXiv:2608.30385

Source
arXiv (en)
Original
https://arxiv.org/abs/2608.30385
License (as archived)
CC0-1.0
Archived
2026-10-17T08:59:40.986Z
SHA-256 of the archived text
b16460ae3535aa06f030248eb7ca499ee6c8ad4952677a7a171abdfd932d28d9
Stable URL of this page
https://metraipolis.com/documento/dc_7d5f97ac3265

How to cite

Detecting DBMS Bugs by Constructing Equivalent Representations of Intermediate Query Results — arXiv:2608.30385 — arXiv (en), https://arxiv.org/abs/2608.30385 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_7d5f97ac3265 (Metraipolis archive dc_7d5f97ac3265, sha256 b16460ae3535aa06f030248eb7ca499ee6c8ad4952677a7a171abdfd932d28d9)
BibTeX
@misc{dc7d5f97ac3265,
  title = {Detecting DBMS Bugs by Constructing Equivalent Representations of Intermediate Query Results — arXiv:2608.30385},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2608.30385},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_7d5f97ac3265; sha256 b16460ae3535aa06f030248eb7ca499ee6c8ad4952677a7a171abdfd932d28d9},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2608.30385. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Database Management Systems (DBMSs) support multiple SQL mechanisms for representing intermediate query results, including VIEWs, Common Table Expressions (CTEs), and Temporary Tables (TEMPTs). When these mechanisms are used to represent the same intermediate query result, the corresponding queries are expected to produce consistent results. However, we observe that such queries can return inconsistent results, indicating potential DBMS logic bugs. Existing approaches for detecting DBMS logic bugs have never explored result consistency across such equivalent representations. In this paper, we propose ERIQ, a novel testing approach for detecting DBMS logic bugs from the perspective of checking result consistency across Equivalent Representations of Intermediate Query Results. ERIQ constructs SQL variants using a VIEW, a CTE, or a TEMPT to represent the same intermediate query result, executes these variants, and compares their returned results. We evaluated ERIQ on four widely used open-source DBMSs: MySQL, MariaDB, Percona, and OceanBase. In total, ERIQ detected 64 bugs, 63 of which were confirmed by developers, and two have been fixed. Among the confirmed bugs, 54 were unique and previously unknown logic bugs, and one was a documentation issue.

Tema degli esploratori: calcolo e infrastrutture (retro-catalogo arXiv: annunci del 2026-09-01 in cs.SE).
Categorie arXiv: Databases (cs.DB) ; Software Engineering (cs.SE).
Pagina del lavoro: https://arxiv.org/abs/2608.30385 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito).
Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina.
Letto il 2026-10-17T08:37:02.102Z dalla pagina https://arxiv.org/catchup/cs.SE/2026-09-01?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).