Hi, Sanja! On Mar 11, sanja@mariadb.com 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