diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/query_cache.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/query_cache.test | 5 |
2 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index 632f64e25de..af14575a812 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -179,8 +179,6 @@ create table t2 (a text not null); create table t21 (a text not null); create table t3 (a text not null); insert into t1 values("1111111111111111111111111111111111111111111111111111"); -insert into t11 select * from t1; -insert into t21 select * from t1; insert into t2 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; @@ -196,6 +194,8 @@ insert into t1 select * from t2; insert into t2 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; +insert into t11 select * from t1; +insert into t21 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; insert into t1 select * from t2; diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index 280f2202af1..b4d00639587 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -93,8 +93,6 @@ create table t2 (a text not null); create table t21 (a text not null); create table t3 (a text not null); insert into t1 values("1111111111111111111111111111111111111111111111111111"); -insert into t11 select * from t1; -insert into t21 select * from t1; insert into t2 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; @@ -110,6 +108,9 @@ insert into t1 select * from t2; insert into t2 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; +# t11 and t21 must be over 4Kb (QUERY_CACHE_MIN_RESULT_DATA_SIZE) +insert into t11 select * from t1; +insert into t21 select * from t1; insert into t1 select * from t2; insert into t2 select * from t1; insert into t1 select * from t2; |