Subject | RE: [firebird-support] NULL and equality |
---|---|
Author | Paul Vinkenoog |
Post date | 2004-05-30T15:47:16Z |
Hi Alan,
I would have no trouble explaining to a MySQL user why "if ( MyField
= NULL )" is Bad (TM). I'm only having trouble explaining that while
"if ( MyField = NULL )" is bad, "set MyField = NULL" is hunky-dory.
Greetings,
Paul Vinkenoog
> My observation is driven by the number of people who are migratingBut I don't know if that should be a reason for us to do the same.
> from MySQL and other databases where it IS legal to test for NULL
> with the equality operator. At times I think that sticking to a
> "standard" is making us look like we are out of step with everyone
> else and certainly out of step with people's expectations. Oracle
> and MS might be bad at some things but they don't let standards per
> se drive there implementation. We all know that they diverge
> frequently from the standard.
I would have no trouble explaining to a MySQL user why "if ( MyField
= NULL )" is Bad (TM). I'm only having trouble explaining that while
"if ( MyField = NULL )" is bad, "set MyField = NULL" is hunky-dory.
Greetings,
Paul Vinkenoog