From: Jay
Date: March 15 1999 3:12pm
Subject: DISTINCT weirdness..
List-Archive: http://lists.mysql.com/mysql/263
Message-Id: <025701be6ef6$4c1c8420$8002a8c0@jay1.intranet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Can someone explain the internals of mySQL's "SELECT DISTINCT" ?

I applaud TCX for it's informative online manual.. but this area seems a bit
sparse.

I've got a TEXT column I'm de-duping, so I brewed up a quick Perl/DBI
de-duper..

It only finds 1 dupe out of 3234 rows, where as SELECT DISTINCT .. into
outfile 'foo' counts 2937 to the file.. so, 297 dupes. Right? (That is if a
dupe is A = B)

This is bizarre to me, I trust my script.. the single dupe it found is* 100%
equal to another record.

I spose I'll run it with... text_column like "$thingy" , and see what
happens.

Thanks..

-Jay J