Re: bzr commit into mysql-5.0 branch (zhenxing.he:2636) Bug#35583

[He Zhenxing]

Andrei Elkin wrote:
> >> >> Thanks for adding the test!
> >> >> 
> >> >> As a comment on it, I thought the test would lists all kinds of
> query
> >> >> on a temporary table and to print the content of the binlog in the
> >> >> end.
> >> >
> >> > I agree to check all update querys that using temporary table would
> make
> >> > the test complete, but I think the idea to print the content of the
> >> > binlog is not good, because that would make the test dependent on the
> >> > format of the binlog dump format, which might change from time to
> time.
> >> 
> >> Well, not all the binlog but only 
> >> 
> >>    $MYSQL_BINLOG binlog | grep 'pseudo_thread_id'
> >> 
> >> would be relevant to show in the results.
> >> 
> >
> > but the thread_id number might change.
> >
> 
> well, then mask out the number. What we really need is the line with
> set @@session.pseudo_thread_id.
> 

Hmm, then we cannot check if the number is correct, i.e. the numbers for
different connections are differenct, and for the same connection they
are the same.