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

[Jørgen Løland]

Øystein Grøvlen wrote:
> 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
> 

You can do that, but I think the result file is easier to read with the 
query.

-- 
Jørgen Løland