From: Greg Willits <lists@...>
Date: 2007-10-29T16:55:22+09:00
Subject: mysql-ruby returns wrong record count

Just started using mysql-ruby, and doing a simply query like this:

select distinct rcrdNo from someTable

I'm getting results back from mysql-ruby that is simply not correct.

rcrdNo is a unique random string that's 20 characters long. The only
thing I can think of is somehow going through mysql-ruby that the full
20 chars is not being considered in DISTINCT?

I can copy/paste the query among different clients, and they all agree
on the records count except for mysql-ruby. In years of using MySQL,
I've never come across a discrepency in a query like this through a
client / interface.

Any ideas?

-- gw
-- 
Posted via http://www.ruby-forum.com/.