Do LLMs Understand Backend Data-Layer Semantics? A Controlled Study of Cross-Endpoint Issues

Francesco Dente, Dario Satriani, Donatello Santoro, Enzo Veltri, Paolo Papotti


Abstract
Evaluating Large Language Models (LLMs) on code review requires moving beyond local syntax to assess system-wide semantic reasoning. We investigate whether LLMs can detect semantic data-layer issues: latent bugs requiring cross-endpoint reasoning over persistent state. We introduce a controlled benchmark of 216 minimal database-backed tasks, derived from 18 independent hand-written scenarios, to evaluate five frontier and open-weights models under two settings: open-ended review versus targeted detection. Our evaluation reveals a stark discovery gap: while models reliably recognize explicitly described issues, they struggle to discover them unprompted, with average F1 dropping from 0.91 to 0.85 for the easiest category and from 0.73 to 0.03 for the hardest. Furthermore, models exhibit a hierarchy of detectability across issue types, and for retention issues, a compliance bias where explicit definitions lead to over-flagging of structurally similar but semantically correct code. Our findings demonstrate that targeted defect detection substantially overestimates true open-ended review capabilities, underscoring the need to evaluate LLMs on latent intent recovery.
Anthology ID:
2026.emnlp-main.2154
Volume:
Proceedings of the 2026 Conference on Empirical Methods in Natural Language Processing
Month:
October
Year:
2026
Address:
Budapest, Hungary
Editors:
Hung-Yi Lee, Sunipa Dev, Jessy Li, Desmond Elliott
Venue:
EMNLP
SIG:
SIGDAT
Publisher:
Association for Computational Linguistics
Note:
Pages:
49005–49019
Language:
URL:
https://aclanthology.org/2026.emnlp-main.2154/
DOI:
Bibkey:
Cite (ACL):
Francesco Dente, Dario Satriani, Donatello Santoro, Enzo Veltri, and Paolo Papotti. 2026. Do LLMs Understand Backend Data-Layer Semantics? A Controlled Study of Cross-Endpoint Issues. In Proceedings of the 2026 Conference on Empirical Methods in Natural Language Processing, pages 49005–49019, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
Do LLMs Understand Backend Data-Layer Semantics? A Controlled Study of Cross-Endpoint Issues (Dente et al., EMNLP 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.emnlp-main.2154.pdf