~james-page/ubuntu/precise/mysql-5.5/misc-fixes

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/t/report_port_basic.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-06-11 07:34:33 UTC
  • mfrom: (1.1.6)
  • Revision ID: package-import@ubuntu.com-20120611073433-l9za2ni4ipp848y3
Tags: 5.5.24-0ubuntu0.12.04.1
* SECURITY UPDATE: Update to 5.5.24 to fix security issues (LP: #1011371)
  - http://dev.mysql.com/doc/refman/5.5/en/news-5-5-24.html

Show diffs side-by-side

added added

removed removed

Lines of Context:
2
2
#
3
3
# only global
4
4
#
5
 
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
 
5
--replace_regex s/[0-9]+/DEFAULT_MASTER_PORT/
6
6
select @@global.report_port;
7
7
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
8
8
select @@session.report_port;
9
 
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
 
9
--replace_column 2 'DEFAULT_MASTER_PORT'
10
10
show global variables like 'report_port';
11
 
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
 
11
--replace_column 2 'DEFAULT_MASTER_PORT'
12
12
show session variables like 'report_port';
13
 
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
 
13
--replace_column 2 'DEFAULT_MASTER_PORT'
14
14
select * from information_schema.global_variables where variable_name='report_port';
15
 
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
 
15
--replace_column 2 'DEFAULT_MASTER_PORT'
16
16
select * from information_schema.session_variables where variable_name='report_port';
 
17
--replace_column 2 'DEFAULT_MASTER_PORT'
17
18
 
18
19
#
19
20
# show that it's read-only