2.1.2.176 T031, BOOLEAN data type
V0212:
The specification states the following:
-
Subclause 5.3, "<literal>": <boolean literal> ::= TRUE | FALSE | UNKNOWN ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <boolean literal>. Subclause 6.1, "<data type>": <boolean type> ::= BOOLEAN ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <boolean type>. Subclause 6.26, "<value expression>": <value expression> ::= <common value expression> | <boolean value expression> | <row value expression> ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <value expression> that is a <boolean value expression>. Subclause 6.35, "<boolean value expression>": <boolean value expression> ::= <boolean term> | <boolean value expression> OR <boolean term> <boolean term> ::= <boolean factor> | <boolean term> AND <boolean factor> <boolean factor> ::= [ NOT ] <boolean test> <boolean test> ::= <boolean primary> [ IS [ NOT ] <truth value> ] ... <boolean primary> ::= <predicate> | <boolean predicand> <boolean predicand> ::= <parenthesized boolean value expression> | <nonparenthesized value expression primary> ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <boolean primary> that simply contains a <nonparenthesized value expression primary>. Subclause 6.3, "<value expression primary>": <nonparenthesized value expression primary> ::= <unsigned value specification> | <column reference> | <set function specification> | <window function> | <scalar subquery> | <case expression> | <cast specification> | <field reference> | <subtype treatment> | <method invocation> | <static method invocation> | <new specification> | <attribute or method reference> | <reference resolution> | <collection value constructor> | <array element reference> | <multiset element reference> | <next value expression> | <routine invocation> Subclause 7.1, "<row value constructor>": <row value constructor predicand> ::= <common value expression> | <boolean predicand> | <explicit row value constructor> ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <row value constructor predicand> that immediately contains a <Boolean predicand>. Subclause 10.9, "<aggregate function>": <computational operation> ::= AVG | MAX | MIN | SUM | EVERY | ANY | SOME | COUNT | STDDEV_POP | STDDEV_SAMP | VAR_SAMP | VAR_POP | COLLECT | FUSION | INTERSECTION ... Conformance Rules Without Feature T031, "BOOLEAN data type", conforming SQL language shall not contain a <computational operation> that immediately contains EVERY, ANY, or SOME.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.