ANSI has completed a new standard for Database Language SQL, SQL - 1992. This standard is composed of three levels of conformance, Full SQL, Intermediate SQL, and Entry SQL. Entry SQL is a slightly enhanced version of the SQL - 1989 standard.The NIST has accepted the ANSI SQL-1992 standard with some modifications. They also added another level, Transitional SQL, between Intermediate SQL and Entry SQL.To test relational database implementations for conformance to the ANSI and Government standards, the NIST created the SQL Test Suite. It consists of eleven test suites including suites for Embedded SQL and Module Language for Ada, C, COBOL, Fortran and Pascal, and a separate suite for Interactive SQL. Currently, the NIST is updating the SQL Test Suite to the Entry SQL standard.There is a need for test suites for Intermediate SQL and Full SQL(possibly also Transitional SQL). This proposal is for an Intermediate SQL Test Suite. It will be composed of twenty-two test suites. These include the eleven in the NIST SQL Test Suite, four more for MUMPS and PL/I, and seven to test Dynamic SQL for each programming language. The Intermediate SQL Test Suite will be fully compatible with the Entry SQL Test Suite.Commercial Applications: SQL-1992 will become an important component in open systems. With the use and number of relational products growing, adherance to the standard will become increasingly crucial.
