Knowledge Base

BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions

Article ID: 152393

Article Last Modified on 3/14/2005

Microsoft SQL Server 6.5 Standard Edition
Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q152393

BUG#: 15390 (SQLBUG_65)
BUG#: 57790 (SQLBUG_70)
BUG#: 227378 (SHILOH)

SYMPTOMS

The SET FIPS_FLAGGER is intended to guard against the unintentional use of nonportable SQL extensions. CUBE and ROLLUP extensions have been added to SQL Server 6.5 and are not part of the FIPS 127-2 standard. A warning is not reported when a SELECT statement with such an extension is executed with the FIPS_FLAGGER option switched on. Failure to report this warning does not invalidate FIPS 127-2 compliance of SQL Server 6.5.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB152393