NIST (the National Institute for Standards and Testing) used to put out tests which "verified" whether a DBMS complied with SQL standard requirements. They are obsolete, but some commentators still refer to them today. Some have even suggested that SQL-92 is preferable to the current standard (SQL-99 aka SQL:1999), because SQL-92 conformance can be "verified" by the NIST tests and SQL-99 cannot be. I have written this article to dispute those suggestions. I have tested the NIST tests, and concluded: Any DBMS which passes the NIST tests is violating the SQL standard.
%0 Generic
%1 Gulutzan2002
%A Gulutzan, Peter
%D 2002
%K sql standard
%T The NIST Tests Were Not Standard SQL
%U http://www.ocelot.ca/nist.htm
%X NIST (the National Institute for Standards and Testing) used to put out tests which "verified" whether a DBMS complied with SQL standard requirements. They are obsolete, but some commentators still refer to them today. Some have even suggested that SQL-92 is preferable to the current standard (SQL-99 aka SQL:1999), because SQL-92 conformance can be "verified" by the NIST tests and SQL-99 cannot be. I have written this article to dispute those suggestions. I have tested the NIST tests, and concluded: Any DBMS which passes the NIST tests is violating the SQL standard.
@misc{Gulutzan2002,
abstract = {NIST (the National Institute for Standards and Testing) used to put out tests which "verified" whether a DBMS complied with SQL standard requirements. They are obsolete, but some commentators still refer to them today. Some have even suggested that SQL-92 is preferable to the current standard (SQL-99 aka SQL:1999), because SQL-92 conformance can be "verified" by the NIST tests and SQL-99 cannot be. I have written this article to dispute those suggestions. I have tested the NIST tests, and concluded: Any DBMS which passes the NIST tests is violating the SQL standard.},
added-at = {2010-10-05T09:48:22.000+0200},
author = {Gulutzan, Peter},
biburl = {https://www.bibsonomy.org/bibtex/2bb12f9710a38b6430b60ac9ea4717827/voj},
interhash = {3b7e983dd498b88ad72888f808c287cd},
intrahash = {bb12f9710a38b6430b60ac9ea4717827},
keywords = {sql standard},
month = {11},
timestamp = {2010-10-05T09:48:22.000+0200},
title = {The NIST Tests Were Not Standard SQL},
url = {http://www.ocelot.ca/nist.htm},
year = 2002
}