Null values in SQL

Authors:
John Grant
Affiliations:
Towson University, Towson, MD and University of Maryland, College Park, MD
Venue:
ACM SIGMOD Record
Year:
2008

Citing 5
Cited 2

Foundations of disjunctive logic programming

Foundations of disjunctive logic programming
An introduction to database systems (7th ed.)

An introduction to database systems (7th ed.)
Foundations of probabilistic answers to queries

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Theory of Relational Databases

Theory of Relational Databases
Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique

ACM SIGMOD Record

White-box testing for database-driven applications: a requirements analysis

Proceedings of the Second International Workshop on Testing Database Systems
NULL 'Value' Algebras and Logics

Proceedings of the 2011 conference on Information Modelling and Knowledge Bases XXII

Quantified Score

Hi-index	0.00

Visualization

Abstract

In various writings over the past 20 years, such as [3], Date has pointed out that SQL produces incorrect answers to some queries where a null value is included in a table. In a recent article in the ACM SIGMOD Record, [8], Rubinson states that "Date misinterprets the meaning of his example query" and "SQL returns the correct answer to the query posed". The purpose of this article is to show that, contrary to Rubinson's claim, Date's critique of query evaluation in the presence of null values in SQL is completely justified.