maria-developers team mailing list archive

Thread
Date

Re: 7ceff99: MDEV-6954: SET STATEMENT rand_seedX = ...FOR ... makes the next rand() to return 0

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: Sergei Golubchik <serg@xxxxxxxxxxx>
Date: Wed, 11 Mar 2015 21:05:12 +0100
Cc: sanja@xxxxxxxxxxx
In-reply-to: <1426068136.536172.2909@bell-ThinkPad>
User-agent: Mutt/1.5.23 (2014-03-12)

Hi, Sanja!

On Mar 11, sanja@xxxxxxxxxxx wrote:
> revision-id: 7ceff99ff25b74bb188848ce0e5f9e2f1ddac3d0
> parent(s): 9f4ee16bf351ea2969d73abcdea92e70538c723c
> committer: Oleksandr Byelkin
> branch nick: server
> timestamp: 2015-03-11 11:02:13 +0100
> message:
> 
> MDEV-6954: SET STATEMENT rand_seedX = ...FOR ... makes the next rand() to return 0
> 
> The variables now return real values. They can't be made usual variables because they do not have DEFAULT value.
> 
> diff --git a/mysql-test/suite/sys_vars/inc/sysvars_server.inc b/mysql-test/suite/sys_vars/inc/sysvars_server.inc
> index fb6121d..3a9a312 100644
> --- a/mysql-test/suite/sys_vars/inc/sysvars_server.inc
> +++ b/mysql-test/suite/sys_vars/inc/sysvars_server.inc
> @@ -17,6 +17,7 @@ select * from information_schema.system_variables
>    where variable_name not like 'aria%' and
>          variable_name not like 'debug%' and
>          variable_name not like 'wsrep%' and
> +        variable_name not like 'rand_seed%%' and

1. why two %% ? :) 
2. there are only two variables here, better list them explicilty in the
   "not in" list
3. if you remove variables from the output here, please add them to the
   select below.

>          variable_name not in (
>            'have_openssl',
>            'have_symlink',

Regards,
Sergei