diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-12-04 23:57:10 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-12-04 23:57:10 +0200 |
| commit | 4eb6fd537b98eabf02b61d4a7979414bf735f784 (patch) | |
| tree | 6b64ebf3494971d1dc96d2ec0b30bfc46e082bcd /mysql-test/t/query_cache.test | |
| parent | 2e939d77dfbfff131a87dbeb30adc5d65393d3bc (diff) | |
| download | mariadb-git-4eb6fd537b98eabf02b61d4a7979414bf735f784.tar.gz | |
fixed length of current database name if it is dropped (BUG#1986)
mysql-test/r/query_cache.result:
test of BUG#1986
mysql-test/t/query_cache.test:
test of BUG#1986
sql/sql_db.cc:
as far as we remove db name we should remove its length
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index 14cbf4c906d..a7f28bfb5b6 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -585,4 +585,17 @@ show status like "Qcache_queries_in_cache"; # Keep things tidy # DROP TABLE t1; + +# +# DROP current database test +# +CREATE TABLE t1 (a int(1)); +CREATE DATABASE mysqltest; +USE mysqltest; +DROP DATABASE mysqltest; +SELECT * FROM test.t1; +USE test; +DROP TABLE t1; + + SET GLOBAL query_cache_size=0; |