Re: bzr commit into mysql-6.0-backup branch (jorgen.loland:2746) Bug#38426

[Øystein Grøvlen]

Jørgen Løland wrote:
> Rafal Somla wrote:
>> You could do it without "replace_regex" as follows:
>>
>> --eval SELECT drivers LIKE '$exp_drv' FROM mysql.backup_history
>>                                       WHERE backup_id=$bup_id;
>>
>> or even:
>>
>> --eval SELECT drivers = '$exp_drv' FROM mysql.backup_history
>>                                    WHERE backup_id=$bup_id;
> 
> I don't think I can - the regex ensures that the result file looks 
> identical even though the value of $exp_drv is different for different 
> storage engines.

I do not think $exp_drv would be displayed if you made an alias for you 
output column.  However, $bup_id would still be a problem.

An alternative to filtering is to instruct the test to not output the 
query in the first place (results will still be printed):

--disable_query_log
--eval SELECT count(*) FROM mysql.backup_history
        WHERE drivers LIKE $exp_drv' AND backup_id=$bup_id
--enable_query_log

-- 
Øystein