diff options
| author | unknown <dlenev@mysql.com> | 2005-04-11 00:30:23 +0400 |
|---|---|---|
| committer | unknown <dlenev@mysql.com> | 2005-04-11 00:30:23 +0400 |
| commit | 3e0a62636725b4bfa958d1416d80a12d269b1b94 (patch) | |
| tree | 399431c2e664a0e664adac3515c389e2d29de3a7 /mysql-test/r/query_cache.result | |
| parent | c6bb22936a220aca3d1b608f467f769d8f5cfab7 (diff) | |
| download | mariadb-git-3e0a62636725b4bfa958d1416d80a12d269b1b94.tar.gz | |
Fix for bug #9796 "Query Cache caches queries with CURRENT_USER()
function".
We should not cache queries using CURRENT_USER() function as we do it
for some other functions, e.g. USER() function.
mysql-test/r/query_cache.result:
Let us test that queries with CURRENT_USER() function are not cached.
mysql-test/t/query_cache.test:
Let us test that queries with CURRENT_USER() function are not cached.
sql/item_create.cc:
create_func_current_user():
We should not cache queries which use CURRENT_USER() function.
Diffstat (limited to 'mysql-test/r/query_cache.result')
| -rw-r--r-- | mysql-test/r/query_cache.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index 85fe77b1f10..a472a1b75c0 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -299,6 +299,8 @@ select UNIX_TIMESTAMP() from t1; UNIX_TIMESTAMP() select USER() from t1; USER() +select CURRENT_USER() from t1; +CURRENT_USER() select benchmark(1,1) from t1; benchmark(1,1) show status like "Qcache_queries_in_cache"; |