List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 31 2006 4:01pm
Subject:Re: SOLVED (was: Weird SELECT bug in 5.0.21)
View as plain text  
In the last episode (Aug 31), Renald Buter said:
> On 12:27 Thu 31 Aug     , Duncan Hill wrote:
> > On Thursday 31 August 2006 12:21, Renald Buter wrote:
> > > The problem is that a simple 1-table query shows different
> > > answers depending on whether you select 1 or 2 columns.
> 
> *blush*
> 
> Of course. I see. How stupid.
> 
> Thanks and sorry to have bothered you.

In your particular case, mysql probably pulled the values for your
1-column query directly from that column's index (which would be
sorted), and your 2-column query either pulled from a different index
or had to actually read table data.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Weird SELECT bug in 5.0.21Renald Buter31 Aug
  • Re: Weird SELECT bug in 5.0.21Renato Golin31 Aug
    • Re: Weird SELECT bug in 5.0.21Renald Buter31 Aug
      • Re: Weird SELECT bug in 5.0.21Duncan Hill31 Aug
        • SOLVED (was: Weird SELECT bug in 5.0.21)Renald Buter31 Aug
          • Re: SOLVED (was: Weird SELECT bug in 5.0.21)Dan Nelson31 Aug