Re: The Practical Benefits of the Relational Model

Nathan Allan wrote:
>
> I appreciate what you are saying, but my point isn't really directed
> at the SQL standard, so much as the entire class of problems inherent
> in the pseudo-3vl style of "nulls". I choose this example from MySQL
> as a classic illustration of the horrendous types of logical problems
> that such nulls invite.

        Yes, but that would be just to criticize female beauty in general because you happen to think the barber's wife nose ugly.

        I agree about NULLs, I just think you should take on the SQL standard itself, not on a half-baked misimplementation.

> Mostly irrelevant aside: Although MySQL may be distant from the
> standard, they have stated their intent to achieve full compliance on
> their site.

        It's doubtful they will ever, because doing so would make their product even slower than it is now. Furthermore there are doubts about whether they understand DBMSs in general, much less SQL in particular.

-- 
  _
/ \ Leandro Guimarães Faria Corsetti Dutra        +41 (21) 216 15 93
\ / http://homepage.mac.com./leandrod/        fax +41 (21) 216 19 04
  X  http://tutoriald.sourceforge.net./      Orange Communications CH
/ \ Campanha fita ASCII, contra correio HTML      +41 (21) 644 23 01