BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions (152393)


The information in this article applies to:

  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MinorLast Reviewed:3/14/2005
Keywords:kbBug kbpending KB152393
©2004 Microsoft Corporation. All rights reserved.