Re: "select distinct" doesn"t coalesce NULL rows

Matthias,

thank you for the bug report. I have now fixed this in both 3.23 and 4.0.
The reason was that MySQL does not ignore the content of a field even if the
field is marked to contain an SQL NULL value.

Heikki
Innobase Oy

How-To-Repeat:


................

Mathias,

Matthias Urlichs wrote:
> Hi,

Thanks a lot for your report. With your Innodb files I was able to repeat it
and

write smaller repeatable test case.

Ther reason I did not confirmed it first time was that query often returns
correct

result when first executed.

Thanks also to Paul who confirmed it too.

Entered as http://bugs.mysql.com/bug.php?id=154

Best regards

--
MySQL Conference and Expo 2003
http://www.mysql.com/events/uc2003/index.html
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski

/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ 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 bugs-thread13972@lists.mysql.com
To unsubscribe, e-mail