|
Published Articles >> Table of Contents >> Abstract
Quality Software, Fourth International Conference on (QSIC'04)
pp. 250-257
Semantic Errors in SQL Queries: A Quite Complete List
Stefan Brass, Martin-Luther-Universität Halle-Wittenberg, Germany
Christian Goldberg, Martin-Luther-Universität Halle-Wittenberg, Germany
Full Article Text:
  
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/QSIC.2004.1357967
Send link to a friend
| Abstract |
|
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 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 database management systems will perform such checks and that the generated warnings will help to develop code with fewer bugs in less time.
|
 Additional Information
|
Citation:
Stefan Brass, Christian Goldberg,
"Semantic Errors in SQL Queries: A Quite Complete List,"
qsic,
pp. 250-257,
Quality Software, Fourth International Conference on (QSIC'04),
2004
|
|
