Re: The NIST tests weren't standard SQL

jarl_at_mimer.com (Jarl Hermansson) wrote in message news:<2aaa8682.0211280212.3a999d26_at_posting.google.com>...
>
> Since the original files contained many obvious errors, I find it hard
> to believe they have all been run by NIST. (Probably they were written
> without the opportunity to verify them.)
>
> Still these tests are a great tool. We use them daily at our R&D
> department.
>

Dear Jarl,

Thanks! I too have been wondering how a DBMS could have passed the NIST tests as I saw them. While researching for my dbazine.com article, I ran into the suggestion that the current SQL standard "is not a real standard any more" because it has no NIST tests, as SQL-92 had. This argument is surely weakened if the NIST tests were flawed. But yes, they're a great "tool".

References: Michael M. Gorman "IS SQL A REAL STANDARD ANYMORE?" http://www.tdan.com/i016hy01.htm, and Shelley Doll, "Is SQL a standard anymore?" builder.com.com/article.jhtml?id=u00320020604dol01.htm.

Peter Gulutzan
www.ocelot.ca Received on Thu Nov 28 2002 - 23:00:40 CET