diff options
| author | unknown <hhunger@hh-nb.hungers> | 2008-04-10 15:14:28 +0200 |
|---|---|---|
| committer | unknown <hhunger@hh-nb.hungers> | 2008-04-10 15:14:28 +0200 |
| commit | b00c536378b56f06d4d721d975161506e7e0cf2a (patch) | |
| tree | 22492296b4e2e26845dc0bc52599125882202ec1 /mysql-test/r/slow_query_log_func.result | |
| parent | 7cce56b2f2da66ce1ee49eb1a82bbf5233791fd8 (diff) | |
| download | mariadb-git-b00c536378b56f06d4d721d975161506e7e0cf2a.tar.gz | |
System variable tests delivered by Folio3 (see WL4288).
BitKeeper/etc/ignore:
Added mysql-test/linux_sys_vars.inc mysql-test/load_sysvars.inc mysql-test/windows_sys_vars.inc to the ignore list
Diffstat (limited to 'mysql-test/r/slow_query_log_func.result')
| -rw-r--r-- | mysql-test/r/slow_query_log_func.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/slow_query_log_func.result b/mysql-test/r/slow_query_log_func.result new file mode 100644 index 00000000000..83edb4c187e --- /dev/null +++ b/mysql-test/r/slow_query_log_func.result @@ -0,0 +1,24 @@ +SET @global_slow_query_log = @@global.slow_query_log; +SET @global_log_output = @@global.log_output; +SET @@session.long_query_time=1; +SET @@global.log_output = 'TABLE'; +'----When slow_query_log = OFF----' +SET @@global.slow_query_log = OFF; +TRUNCATE mysql.slow_log; +SELECT sleep(2); +sleep(2) +0 +SELECT count(*) FROM mysql.slow_log; +count(*) +0 +'----When slow_query_log = ON-----' +SET @@global.slow_query_log = ON; +TRUNCATE mysql.slow_log; +SELECT sleep(2); +sleep(2) +0 +SELECT count(*) FROM mysql.slow_log; +count(*) +1 +SET @@global.log_output = @global_log_output; +SET @global.slow_query_log = @global_slow_query_log; |