Re: The NIST tests weren't standard SQL

pgulutzan_at_ocelot.ca (Peter Gulutzan) wrote in message news:<36c478c6.0211261355.21a3c1f3_at_posting.google.com>...
> Some time ago I had a look at the NIST tests for SQL DBMS compliance,
> and concluded that -- despite their obvious merits -- they required
> that the DBMS violate the ANSI/ISO SQL standards. I've decided to
> resurrect my notes about some apparent deviations, and see if anyone
> wishes to refute them. The page is http://www.ocelot.ca/nist.htm.
>
> Peter Gulutzan
> Author of "SQL Standards" article (http://dbazine.com/gulutzan3.html)

Dear Peter,

We started using these NIST tests years ago (mid 90's?). During the first year we sent NIST a big number of corrections, which where approved. Then the NIST project was discontinued, so the 'official' files haven't been updated for many years. However, we still find a few errors now and then.

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.

Regards,
Jarl Received on Thu Nov 28 2002 - 11:12:15 CET