>From: [EMAIL PROTECTED] > >After adding a key to a nullable column, null values will >successfully join through to null values in other tables.
And this is a problem because? :-) Seriously, it may be a bug, but IMHO it is a design flaw to index a NULL field. Indexed fields should always be NOT NULL, with the possible exception of FULLTEXT indeces. But if one DOES have NULLs in an indexed field, I'd fully expect them to match and join other NULLs. ---- SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL ---- -- : Jan Steinman -- nature photography: <http://www.Bytesmiths.com> : Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> : Join the forums at <http://www.Bytesmiths.com/wiki> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
