diff options
| author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
|---|---|---|
| committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
| commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
| tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/t/log_basic.test | |
| parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
| download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz | |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
Diffstat (limited to 'mysql-test/t/log_basic.test')
| -rw-r--r-- | mysql-test/t/log_basic.test | 60 |
1 files changed, 0 insertions, 60 deletions
diff --git a/mysql-test/t/log_basic.test b/mysql-test/t/log_basic.test deleted file mode 100644 index b9a64f8981b..00000000000 --- a/mysql-test/t/log_basic.test +++ /dev/null @@ -1,60 +0,0 @@ -###################### mysql-test\t\log_basic.test ############################ -# # -# Variable Name: log_basic # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: string # -# Default Value: # -# Range: # -# # -# # -# Creation Date: 2008-02-07 # -# Author: Rizwan # -# # -# Description: Test Cases of Dynamic System Variable log # -# that checks the behavior of this variable in the following ways# -# * Default Value # -# * Valid & Invalid values # -# * Scope & Access method # -# * Data Integrity # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # -# # -############################################################################### - ---source include/load_sysvars.inc - -##################################### -## START OF log TESTS ## -##################################### - ---echo '#--------------------FN_DYNVARS_062_01------------------#' -############################################################# -# Accessing variable # -############################################################# - -SELECT @@global.log AS INIT_VALUE; - -SELECT @@log AS INIT_VALUE; - -SET @@global.general_log = ON; - -SET global general_log = 0; - ---echo 'Bug# 34832: log is a system but it is not accessible using SET @@global.log;' ---echo 'SET GLOBAL log; and SELECT @@global.log. SHOW VARIABLES shows the value of log.' - - ---echo '#--------------------FN_DYNVARS_062_02-------------------------#' -################################################################################### -# Check if the value in GLOBAL Table matches value in variable # -################################################################################### -# We can only access log value from information schema global_variables table -SELECT VARIABLE_VALUE -FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='log'; - -############################################ -# END OF log TESTS # -############################################ |