MySQL Bugs: #20606: REOPEN BUG Bug #20553 Classified Can't repeat

Bug #20606	REOPEN BUG Bug #20553 Classified Can't repeat
Submitted:	21 Jun 2006 12:52	Modified:	21 Jun 2006 14:02
Reporter:	Andrea Pantaleoni	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.22	OS:	Linux (UBUNTU 5 LINUX)
Assigned to:		CPU Architecture:	Any

Description:
I repeated the bug 20553 and I got the same wrong result it was indicated.
please repeat the procedure carefully

How to repeat:
1) CREATE TABLE `test` (
`A` int(11) NOT NULL, 
KEY `A`(`A`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2) INSERT INTO Test values (4),(4),(3),(2),(3),(1),(3),(4),(4),(1);

3) SELECT DISTINCT A,A as m FROM TestTest order by A;

4) I got:

A m
4 4
4 4
4 4
4 4

Thank you for the bug report. I was unable to repeat with the
current source server as well as reported in the bug:
http://bugs.mysql.com/bug.php?id=20553

mysql> SELECT DISTINCT A,A as m FROM test order by A;
+---+---+
| A | m |
+---+---+
| 1 | 1 | 
| 2 | 2 | 
| 3 | 3 | 
| 4 | 4 | 
+---+---+
4 rows in set (0.01 sec)

mysql> select version();
+--------------+
| version()    |
+--------------+
| 5.0.23-debug | 
+--------------+
1 row in set (0.00 sec)

mysql> 

Is our policy to test against the latest source and I assume how reported
you are using the version 5.0.22. That is correct?

Thanks in advance.

the version I used it was 5.0.22-standard.

I repeated the same operation but with ENGINE=InnoDB and it worked fine.
Are you sure you are repeating the example with MyIsam engine?

Thank you for the feedback. I am changing the status as duplicate
of http://bugs.mysql.com/bug.php?id=20553. Please if you want
to make more comment about, add them to the bug 20553.
Thanks.