.png){kind=icon}
Return
Semantic errors in SQL queries: A quite complete list
.png){kind=icon}
PRE
AI
DOI：10.1016/j.jss.2005.06.028.png)
.png){kind=icon}
Original request for help.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
We investigate classes of SQL queries which are syntactically correct, but certainly not intended, no matter for which task the query was written. For instance, queries that are contradictory, i.e. always return the empty set, are obviously not intended. However, current database management systems (DBMS) execute such queries without any warning. In this paper, we give an extensive list of conditions that are strong indications of semantic errors. Of course, questions like the satisfiability are in general undecidable, but a significant subset of SQL queries can actually be checked. We believe that future DBMS will perform such checks and that the generated warnings will help to develop application programs with fewer bugs in less time. (c) 2005 Elsevier Inc. All rights reserved.
Keywords:
databases
SQL
queries
bugs
errors
semantic errors
logical errors
software correctness
static analysis
teaching
database courses
SQL exams
AI Summary
Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.
Journal
IF:
4.1
Papers:
5.5K
Citations:
8.4K
Organization
No organization information available
Cited Papers
.png){kind=icon}
Henoch-Schönlein purpura in children: its relation to oral and to oral and oral and dental health
OAAI
OAAIShareSaveShareSave
ShareSave
View more