← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/t/lower_case_table_names_basic.test
 
1
#
 
2
# only global
 
3
#
 
4
# 2010-01-20 OBN - Modified to include check for valid values
 
5
#                - Added check for variable value matching I_S tables
 
6
#
 
7
 
 
8
select @@global.lower_case_table_names=20;
 
9
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
10
select @@session.lower_case_table_names;
 
11
 
 
12
# Show variable has a valid value
 
13
SELECT @@global.lower_case_table_names in (0,1,2);
 
14
 
 
15
# Show that value of the variable matches the value in the GLOBAL I_S table
 
16
SELECT @@global.lower_case_table_names = VARIABLE_VALUE
 
17
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
18
WHERE VARIABLE_NAME='lower_case_table_names';
 
19
 
 
20
# Show that value of the variable matches the value in the SESSION I_S table
 
21
SELECT @@global.lower_case_table_names = VARIABLE_VALUE
 
22
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
23
WHERE VARIABLE_NAME='lower_case_table_names';
 
24
 
 
25
#
 
26
# show that it's read-only
 
27
#
 
28
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
29
set global lower_case_table_names=1;
 
30
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
31
set session lower_case_table_names=1;
 
32