dynamobi/dynamobi — Issue #865: [FRG-5] SQL2003 compatability mode: BLOB/VARBINARY/BINARY inequality comparisons
Author: dynamobi-build
Created: 2011-12-30 03:53:41+00:00
State: open
Labels: FRG, SQL Validator

[reporter="johnk", created="Thu, 8 Dec 2005 15:15:21 -0500 (GMT-05:00)"]
Farrago & Fennel aren't SQL2003 compliant in that they allow inequality testing of BLOB/VARBINARY/BINARY types, rather than strict equality testing.

A future compatability mode should address this extension. Also, perhaps this extension should be documented.

See bug FNL-1 and also:

SQL2003 Part 2 Section 4.3.2 and

SQL2003 Part 2 Section 8.2 General Rule 4

SQL99 Part 2 Section 4.2.1

SQL99 Part 2 Section 8.2, General Rule 3