diff options
| author | jimw@mysql.com <> | 2006-05-08 16:38:45 -0700 |
|---|---|---|
| committer | jimw@mysql.com <> | 2006-05-08 16:38:45 -0700 |
| commit | ebe38efaa6feaff5dd7f1e5dfb8dbd6cbf253c29 (patch) | |
| tree | 61a75e4b77c3ded4e660e42076b4d7cc71af45ab /mysql-test/r/variables.result | |
| parent | 91031fc2bc34c5bb020e2696e7f519a98b71e774 (diff) | |
| download | mariadb-git-ebe38efaa6feaff5dd7f1e5dfb8dbd6cbf253c29.tar.gz | |
Bug #1039: tmpdir and datadir not available via @@ system variable syntax
Bug #19606: ssl variables are not displayed in show variables
Bug #19616: log_queries_not_using_indexes is not listed in show variables
Make basedir, datadir, tmpdir, log_queries_not_using_indexes, ssl_ca,
ssl_capath, ssl_cert, ssl_cipher, and ssl_key all available both from
SHOW VARIABLES and as @@variables.
As a side-effect of this change, log_queries_not_using_indexes can
be changed at runtime (but only globally, not per-connection).
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 32cd8790874..70586a3e1e9 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -612,4 +612,32 @@ select @@version, @@version_comment, @@version_compile_machine, @@version_compile_os; @@version @@version_comment @@version_compile_machine @@version_compile_os # # # # +select @@basedir, @@datadir, @@tmpdir; +@@basedir @@datadir @@tmpdir +# # # +show variables like 'basedir'; +Variable_name Value +basedir # +show variables like 'datadir'; +Variable_name Value +datadir # +show variables like 'tmpdir'; +Variable_name Value +tmpdir # +select @@ssl_ca, @@ssl_capath, @@ssl_cert, @@ssl_cipher, @@ssl_key; +@@ssl_ca @@ssl_capath @@ssl_cert @@ssl_cipher @@ssl_key +# # # # # +show variables like 'ssl%'; +Variable_name Value +ssl_ca # +ssl_capath # +ssl_cert # +ssl_cipher # +ssl_key # +select @@log_queries_not_using_indexes; +@@log_queries_not_using_indexes +0 +show variables like 'log_queries_not_using_indexes'; +Variable_name Value +log_queries_not_using_indexes OFF End of 5.0 tests |