search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

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

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[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 commented 12 years ago

[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.