diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-11-22 00:33:15 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-11-22 00:33:15 +0200 |
| commit | 03ac294cceb5619557fffacbf95901f4c5b1997f (patch) | |
| tree | b435c42cf5ff11d8d099465a4944b83164c4bdee /mysql-test/r/innodb_cache.result | |
| parent | 910849ccd1f5f24e90de0f48091a4c6981c71126 (diff) | |
| download | mariadb-git-03ac294cceb5619557fffacbf95901f4c5b1997f.tar.gz | |
fixed invalidation of query cache
excluded double call of 'invalidate()'
mysql-test/r/innodb_cache.result:
test of invalidation
mysql-test/t/innodb_cache.test:
test of invalidation
sql/handler.cc:
excluded double call of 'invalidate()'
sql/sql_delete.cc:
fixed invalidation of query cache
sql/sql_insert.cc:
fixed invalidation of query cache
sql/sql_update.cc:
fixed invalidation of query cache
Diffstat (limited to 'mysql-test/r/innodb_cache.result')
| -rw-r--r-- | mysql-test/r/innodb_cache.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_cache.result b/mysql-test/r/innodb_cache.result index eaa030046da..47abcb45fe5 100644 --- a/mysql-test/r/innodb_cache.result +++ b/mysql-test/r/innodb_cache.result @@ -98,3 +98,13 @@ commit; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 +drop table if exists t1; +CREATE TABLE t1 (id int(11) NOT NULL auto_increment, PRIMARY KEY (id)) TYPE=InnoDB; +select count(*) from t1; +count(*) +0 +insert into t1 (id) values (0); +select count(*) from t1; +count(*) +1 +drop table t1; |