G
Greg Willits
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
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