loading...
Semantic Errors in SQL Queries: A Quite Complete List
Braunshweig, Germany September 08-September 10
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/QSIC.2004.1357967Quality Software, Fourth Internationa ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Stefan Brass, Martin-Luther-Universit?t Halle-Wittenberg, Germany
Christian Goldberg, Martin-Luther-Universit?t Halle-Wittenberg, Germany
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.
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
Usage of this product signifies your acceptance of the Terms of Use.