{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,19]],"date-time":"2026-03-19T16:51:09Z","timestamp":1773939069514,"version":"3.50.1"},"reference-count":9,"publisher":"Association for Computing Machinery (ACM)","issue":"3","license":[{"start":{"date-parts":[[2008,9,30]],"date-time":"2008-09-30T00:00:00Z","timestamp":1222732800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2008,9,30]]},"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.1145\/1462571.1462575","type":"journal-article","created":{"date-parts":[[2008,12,3]],"date-time":"2008-12-03T21:56:04Z","timestamp":1228341364000},"page":"23-25","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":10,"title":["Null values in SQL"],"prefix":"10.1145","volume":"37","author":[{"given":"John","family":"Grant","sequence":"first","affiliation":[{"name":"Towson University, Towson, MD and University of Maryland, College Park, MD"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2008,9,30]]},"reference":[{"issue":"3","key":"e_1_2_1_1_1","first-page":"23","volume":"7","author":"Codd E.F.","year":"1975","unstructured":"E.F. Codd . Understanding relations (installment #7). FDT Bulletin of ACM-SIGMOD , 7 ( 3-4 ): 23 -- 28 , 1975 . E.F. Codd. Understanding relations (installment #7). FDT Bulletin of ACM-SIGMOD, 7(3-4):23--28, 1975.","journal-title":"FDT Bulletin of ACM-SIGMOD"},{"key":"e_1_2_1_2_1","volume-title":"An Introduction to Database Systems","author":"Date C.J.","year":"1975","unstructured":"C.J. Date . An Introduction to Database Systems . Addison-Wesley Publishing Co. , Reading, MA , 1975 . C.J. Date. An Introduction to Database Systems. Addison-Wesley Publishing Co., Reading, MA, 1975."},{"key":"e_1_2_1_3_1","volume-title":"An Introduction to Database Systems","author":"Date C.J.","year":"2000","unstructured":"C.J. Date . An Introduction to Database Systems , 7 th Edition. Addison-Wesley Publishing Co. , Reading, MA , 2000 . C.J. Date. An Introduction to Database Systems, 7th Edition. Addison-Wesley Publishing Co., Reading, MA, 2000.","edition":"7"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1080\/0025570X.1974.11976401"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1016\/0020-0190(77)90013-8"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.5555\/128919"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/1097039"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1361348.1361350"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066303"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1462571.1462575","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1462571.1462575","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T13:30:15Z","timestamp":1750253415000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1462571.1462575"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2008,9,30]]},"references-count":9,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2008,9,30]]}},"alternative-id":["10.1145\/1462571.1462575"],"URL":"https:\/\/doi.org\/10.1145\/1462571.1462575","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2008,9,30]]},"assertion":[{"value":"2008-09-30","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}