Artem, Thursday, October 24, 2002, 7:34:02 PM, you wrote: AK> Description: AK> Probably it's variation of recent bug with null joins, but just in case I want to post it here because result depends on values inserted into tables, even if these values are not participating in AK> join. AK> After data insert with nulls the same query will produce different result after add index.
Thanks for the report! Yes, this bug was recently fixed and changes will come in 4.0.5 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
