[FRG-5] SQL2003 compatability mode: BLOB/VARBINARY/BINARY inequality comparisons

[dynamobi-build]

[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

[dynamobi-build]

[author="jvs", created="Fri, 9 Dec 2005 01:06:58 -0500 (GMT-05:00)"]
We suspect that if the standard ever admits BINARY and VARBINARY, these rules will change. It was agreed that rather than flagging inequality usages as compliance warnings, we should instead flag usage of BINARY and VARBINARY themselves.