2.1.2.86 F571, Truth value tests

  • Article

V0122:

The specification states the following:

 Subclause 6.35, "<boolean value expression>":
  
 <boolean test> ::=
 <boolean primary> [ IS [ NOT ] <truth value> ]
  
 <truth value> ::=
 TRUE
 | FALSE
 | UNKNOWN
  
 <boolean primary> ::=
 <predicate>
 | <boolean predicand>
  
 ...
  
 Conformance Rules
  
 Without Feature F571, "Truth value tests", conforming SQL language shall not contain a <boolean test> that simply contains a <truth value>.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.