Jigal
>Anyway, I gues it's just a question of following a standard and optimizing
>the engine according to that standard.
Your proposal would permit dupe primary keys. It's a question of
preventing them.
PB
-----
Jigal van Hemert wrote:
>From: "Mikhail Entaltsev"
>
>Mikhail,
>
>
>
>>Before inserting MySQL will try to find a record with the same values.
>>But since comparison with NULL value returns always FALSE
>>MySQL will think that there is no such record in the table.
>>After this point you will get 2 identical records in the table.
>>
>>
>
>MySQL as a whole seems a bit more flexible:
>a UNIQUE index allows multiple NULL values (which seems to follow the NULL
>handling you describe), but with BDB table only a single NULL value is
>allowed in a UNIQUE index (so MySQL seems to be able to find a NULL value in
>de db).
>
>Anyway, I gues it's just a question of following a standard and optimizing
>the engine according to that standard.
>
>Regards, Jigal.
>
>
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005
