diff options
| author | pem@mysql.com <> | 2004-08-23 15:29:55 +0200 |
|---|---|---|
| committer | pem@mysql.com <> | 2004-08-23 15:29:55 +0200 |
| commit | 66a3f65d98698895a6fb0b77f3ab279f7032e5fe (patch) | |
| tree | cc10ea4b2e9efa4d9bf1c87d78e0cd35dee56059 /mysql-test | |
| parent | d5bf903e4d05260a596c512efba2412c0807a30b (diff) | |
| download | mariadb-git-66a3f65d98698895a6fb0b77f3ab279f7032e5fe.tar.gz | |
Fixed: BUG#5135: cannot turn on log_warnings with SET in 4.1 (and 4.0)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/variables.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/variables.test | 10 |
2 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index e36f4165f46..13d09e09783 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -381,3 +381,19 @@ set global myisam_max_sort_file_size=4294967296; show global variables like 'myisam_max_sort_file_size'; Variable_name Value myisam_max_sort_file_size MAX_FILE_SIZE +set @tstlw = @@log_warnings; +show global variables like 'log_warnings'; +Variable_name Value +log_warnings 1 +set global log_warnings = 0; +show global variables like 'log_warnings'; +Variable_name Value +log_warnings 0 +set global log_warnings = 42; +show global variables like 'log_warnings'; +Variable_name Value +log_warnings 42 +set global log_warnings = @tstlw; +show global variables like 'log_warnings'; +Variable_name Value +log_warnings 1 diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index b9aa52ec627..03e4778d9d6 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -276,3 +276,13 @@ select @@session.key_buffer_size; set global myisam_max_sort_file_size=4294967296; --replace_result 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE show global variables like 'myisam_max_sort_file_size'; + +# BUG#5135: cannot turn on log_warnings with SET in 4.1 (and 4.0) +set @tstlw = @@log_warnings; +show global variables like 'log_warnings'; +set global log_warnings = 0; +show global variables like 'log_warnings'; +set global log_warnings = 42; +show global variables like 'log_warnings'; +set global log_warnings = @tstlw; +show global variables like 'log_warnings'; |