List:Commits« Previous MessageNext Message »
From:Guilhem Bichot Date:April 26 2011 8:44am
Subject:Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522
View as plain text  
>>  > +select 1 from
>>  > +(t1 join t2 join t3)
>>  > +left join t4 on 1
>>  > +left join t5 on 1 like t4.col253
>>  > +left join t6 on t5.col712 is null
>>  > +left join t7 on t1.b<=>t7.col319
>>  > +left join t8 on t3.col582<=  1;
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>  > +1
>>
>> This result is a bit "boring" ;-) I suggest using "select count(*)"
>> instead of "select 1".  Also makes it easier to spot differences
>> between result files.
> 
> done. And I verified that without the bugfix, the count is wrong.

hadn't looked well: without the bugfix, the assertion fires, as in the 
bug report. All as expected.
Thread
bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Guilhem Bichot1 Apr
  • Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Øystein Grøvlen6 Apr
    • Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Guilhem Bichot26 Apr
      • Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Guilhem Bichot26 Apr
  • Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Roy Lyseng8 Apr
    • Re: bzr commit into mysql-trunk branch (guilhem.bichot:3348) Bug#11766522Guilhem Bichot26 Apr